1 Reply Latest reply: Dec 21, 2017 3:43 AM by Anil Babu RSS

    How To convert calculation from qlik sense to tableau

    natasha A

      Hi All,


      I want to know, how the following conditions from Qlik sense to be converted into Tableau readable conditions.

       

      sum(IF(YYYYMM=$(vCM),[QU_ITM_LM_RTN_SLS],0))/Count ( distinct IF(YYYYMM=$(vCM),ID_TRN,0))-

      sum(IF(YYYYMM=$(vCM)-1,[QU_ITM_LM_RTN_SLS],0))/Count ( distinct IF(YYYYMM=$(vCM)-1,ID_TRN,0))

       

      Thanks In Advance,

      Natasha