9 Replies Latest reply: Jul 30, 2017 4:41 AM by Karthik S RSS

    cyclic dimension giving null values

    arul settu

      Hi,

           i am trying to show top 10 values based on rank function. in qlik sense there is no cyclic group. so i followed this doc

      Makes Sense to go round in circles

       

      my expression is like this

       

      if(vLossratio=1,COUNT({<LR_BW_MAKE_DESC = {"=Rank(COUNT({1<BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID))<=10"}, BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID),

      if(vLossratio=2 ,COUNT({<LR_BW_MODEL_DESC = {"=Rank(COUNT({1<BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID))<=10"}, BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID),

      if(vLossratio=3 ,COUNT({<LR_BW_USAGE_DESC = {"=Rank(COUNT({1<BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID))<=10"}, BW_FM_DT_YEAR = {'$(=Max(BW_FM_DT_YEAR))'}>}LR_BW_VEH_ID))))

       

       

      but it showing null values too. same expression working fine in qlikview.

       

      can anyone suggest some idea on this

       

      Thank you