5 Replies Latest reply: Apr 29, 2016 7:34 PM by Sunny Talwar RSS

    I'm getting a different results from Qlikview script and set analysis expression. Please let me know where i am doing a mistake.

    Padam Tripathi

      I'm getting a different results from Qlikview script vs set analysis expression. Please let me know where i am doing a mistake.

       

      Script Expression:

       

      Count(DISTINCT If( (Col1>= Date(AddMonths(Today(), -1), 'DD/MM/YYYY') and Col1<= Date(Today(), 'DD/MM/YYYY'))

         AND ( LOGON_IND='Y' OR MOB_IND= 'Y' OR TBLT_ND='Y' OR FLG='Y' )

                          , NO))

       

       

      SET Analysis Expression:

       

      Count({$<Col1= {">=$(=Date(AddMonths(Today(), -1), 'DD/MM/YYYY'))<=$(=Date(Today(), 'DD/MM/YYYY'))"}> * (<LOGON_IND={'Y'}> + <MOB_IND={'Y'}> + <TBLT_IND={'Y'}> + <FLG={'Y'}> )}  DISTINCT NO)