Bonjour,
Je viens (encore) avec une bête question
Je dois filtrer une galerie sur base base de la valeur d'une variable (Var1)
J'ai écris ceci :
if(var1="0";
Filter(.....) ; <=== Il m'indique une faute ici
if(var1="1";
Filter(.....);
If(var1="3";
Filter(.....);
...
If(var1="5";
Filter(.....)
Quelqu'un peut-il m'aider ? Merci pour votre aide
Solved! Go to Solution.
bonjour v-xida-msft et mdevaney,
Merci pour votre aide et vos réponses, je teste tout ça ....
@+
@Kervin
I suggest you use a SWITCH function instead. If there is still an error please take a screenshot of the error message and post it to the forums.
Switch(var1;
"0"; Filter(.....);
"1"; Filter(.....);
"3"; Filter(.....);
"5"; Filter(.....)
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @Kervin ,
Could you please share more details about the error message within your Filter function?
Please consider take a try to modify your formula as below:
Filter(
'Your Data Source';
If(
var1 = "0";
FilteredColumn = var1; // Type proper filter condition for var1="0" here
var1 = "1";
FilteredColumn2 = var1; // Type proper filter condition for var1="1" here
var1 = "3";
FilteredColumn3 = var1; // Type proper filter condition for var1="3" here
...
...
)
)
In addition, I also agree with @mdevaney 's thought almost. You could achieve your needs using Switch function instead of If function:
Switch(
var1;
"0"; Filter(....);
"1"; Filter(....);
"3"; Filter(....);
...
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
An honest question: if the idea I supplied is already good why bother to COPY + PASTE what I wrote into your own post? 🙄 Its simply enough to acknowledge my good work and carry on 😎
bonjour v-xida-msft et mdevaney,
Merci pour votre aide et vos réponses, je teste tout ça ....
@+
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |