I am having an issue getting an if statement to work for one of the variables I have set up.
I am basically creating a drop down for days of the week and then want to show a count of a field when selected.
When I use one variable I can get it to work such as below, but when trying a few it wont work. Anyone know what I am doing wrong and how it can be resolved ?
Will return Count(MVT) when vdaydropdown is set to 'Mon', and in all other cases, will return either true or false depending on what the condition Day_name - 'Mon' evaluated to.
This doesn't look like a valid set of nested if() statements and it doesn't seem to have any logical flow to it either - in this scenario, even if it worked, the result for any day selected would be Count(MVT)?
The syntax for nesting if() statements would typically be something like
I am new to Qlicksense so might be wrong the way i am writing it. I am trying to say when my variable is set to Mon then count(Mvt) where the field that is behind the variable is also to Mon. Is there a need to include the final clause?
Will return Count(MVT) when vdaydropdown is set to 'Mon', and in all other cases, will return either true or false depending on what the condition Day_name - 'Mon' evaluated to.
A quick one so im not returning with a similar question , When square brackets are used can you just filter out/In conditions after using an aggregate function.
