Hey everyone, how are you?
I was wondering, is there a simple way to have a default selection for a filter on Qlik Cloud? (knowing we can't use extensions)
I'm doing this with if statements. But then I have to apply this too many times, it's exausting (and hard to edit later if I need to).
Here's the code if anyone is interested. It consideres the current year if no filter is selected.
if(GetSelectedCount(Year)>0,
Sum(Cost)
, //else
Sum({$<Year={'$(=year(now()))'}>} Cost)
)
Thank you!