6 Replies Latest reply: Apr 25, 2018 2:36 PM by Sasidhar Parupudi RSS

    Qlik set analysis

    Prashant Sancheti

      Hi Team,

       

      Scenario:


      • One business date will be always selected
      • For that business date we are adding ITDSales value for Business Date= Last Year Last date + YTDSales value for current business date
      • I have plotted this with one bar chart having customer as dimension and measure as following. :

       

      Total ITDSales  =

       

      if( Sum([Discount])>=1000,


      num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales]) + sum([YTDSales]),'#,##0')


      )

       

      • I  want to count the only customer where Discount is greater  than 1000. for above measure in chart
      • I am writing below expression but i am not getting exact count .

       

      Total Customer Count

       

      Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)


      Could you please help on same



        • Re: Qlik set analysis
          Aun Ahsan

          Count({<[Discount]={'>=1000'} >} distinct Customer)


          The above expression is working for me, can you give it a go?

          • Re: Qlik set analysis
            Sunny Talwar

            What are you getting and what do you expect to get? Expression's syntax looks right, but difficult to say what might be wrong without having more details

              • Re: Qlik set analysis
                Prashant Sancheti
                • One business date will be always selected
                • For that business date we are adding ITDSales value for Business Date= Last Year Last date + YTDSales value for current business date
                • I have plotted this with one bar chart having customer as dimension and measure as following. :

                Total ITDSales  = if( Sum([Discount])>=1000,
                num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales]) + sum([YTDSales]),'#,##0')
                )

                • I am counting the rows after export and  i want to show the Count in KPI
                • I am writing below expression but i am not getting exact count . It is showing count of all the customer . It is not showing count the only customer where Discount is greater  than 1000.

                 

                Total Customer Count

                 

                Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)


                I