5 Replies Latest reply: Mar 22, 2018 10:23 AM by Sunny Talwar RSS

    Set Analysis in Qlik Sense

    Dan Green

      I have a chart where my dimension is ReportDate and I am using set analysis to only show my measures for the most recent 5 report days. In QlikView this would have removed 3/12/18 and 3/13/18. How can I remove those dates in Qlik Sense so that only the dates where I am showing data appear on the chart? I tried toggling on and off "Include Null Values" but have not had luck.

       

      IF([Amount/Count] = 'Count', Num(Sum({$<ReportDate = {'>=$(vReportLast5Days)'}>}OR_EfftAge_0_30Cnt)/1000,'###K;(###K)'), Num(Sum({$<=ReportDate = {'>$(vReportLast5Days)'}>}OR_EfftAge_0_30Amt)/1000000, '$###M;($###M)'))

       

      vReportLast5Days =Date(Max(ReportDate)-5)

       

        • Re: Set Analysis in Qlik Sense
          Sunny Talwar

          Did you try to uncheck 'Include Zero Value' on the under Add-ons -> Data handling?

            • Re: Set Analysis in Qlik Sense
              Dan Green

              That was the issue. Something else that is happening is if i select one of the dates to filter on it, it then shows all dates instead of just one. It also ignores the Count filter. With this set to Count and 3/15/18 this is my chart...

               

                • Re: Set Analysis in Qlik Sense
                  Sunny Talwar

                  well you set analysis is saying show everything greater than Date(Max(ReportDate)-5)... basically it will show everything available above your selected date.... may be try this


                  IF([Amount/Count] = 'Count', Num(Sum({$<ReportDate *= {'>=$(vReportLast5Days)'}>} OR_EfftAge_0_30Cnt)/1000,'###K;(###K)'), Num(Sum({$<=ReportDate *= {'>$(vReportLast5Days)'}>} OR_EfftAge_0_30Amt)/1000000, '$###M;($###M)'))

                    • Re: Set Analysis in Qlik Sense
                      Dan Green

                      This worked, although I still don't understand why if I selected 3/15/18 it then showed all information unless it was taking 3/15 as the max, subtracting 5 days, and then showing everything greated. But even then it messed up the bar for that day. I thought they way I had it it would have shown the current selection or the last 5 days. Thank you for the help though!