2 Replies Latest reply: May 13, 2016 10:37 AM by Michelle Tapper RSS

    Set analysis (works in QlikView, not in Sense...)

    Michelle Tapper

      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