1 Reply Latest reply on Dec 20, 2016 12:25 PM by Patrick A Van Der Hyde

    Need help in converting conditional calculation from qlik sense to tableau.

    rohit chourasia

      hi Guys,

       

      Im new to Tableau, i need 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))

       

      thank you,

      rohit