4 Replies Latest reply: Dec 4, 2017 11:55 AM by Herve Boulnois RSS

    Date filter doens't work in a set analysis

    Herve Boulnois

      Hello all


      Here is my problem :


      I use Qlik Sense Desktop. In a KPI, I have two statements :


      one for the title :

      =Date(MonthEnd(AddMonths(Max(Date_F),-1)),'DD MMMM YYYY')


      one for the datas :

      =sum( {$< [Date_F] = {"$(=Date(MonthEnd(AddMonths(Max(Date_F),-1)),'DD/MMMM/YYYY'))"},[Client externe]={"-1"} >} (NbVMPwrOff+NbVMPwrOn))


      The first statement works great.

      The second doen't work (result =0), but I know that it should give something else.


      Is there a syntax problem ?


      Thanks a lot for any help.