Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a problem with set analysis...
I have a set analysis that works in QlikView but not in Qlik Sense (see below). I know it would be a lot better to work with variables but our customer use an older version of Sense that does not handle dynamic variables.
Have any of you experienced anything similar or have any suggestion to me??
The set analysis:
Sum( {$< Datum={">=$(=if(Max(Datum)>Date(Today()), WeekStart(Today()-35), WeekStart(Max(Datum)-35)) )<=$(=if(Max(Datum)>Date(Today()), WeekEnd(Today()-7), WeekEnd(Max(Datum)-7)))"} >} Belopp)
Thank you, thank you, thank you!!!!!!!!!!!!!!!!!!!!!!!!!
Regards
Michelle
Have you double checked the date formats returned from the dollar sign expansions, compared to the Datum field format?
And could you be a bit more detailed what you mean with 'not working'?
Hi and thanks for the tip!
It took me the right way. The format was correct but I had to switch from English to Swedish collation to get it right. Took some time to get it right but in the end it worked out!!
You saved my weekend
Regards
Michelle