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

cyclic dimension giving null values

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

• Re: cyclic dimension giving null values

HI,

un check the option show null values in object properties

• Re: cyclic dimension giving null values

i tried that also but no use

• Re: cyclic dimension giving null values

here is the sample app. some one suggest some idea

• Re: cyclic dimension giving null values

Hi Arul,

With Qliksense 2.2 you have alternate dimensions which will help you swap dimensions. Did you try that? If so its worth giving a try as it would ease what you are trying to achieve.

Thanks,

Sangram.

• Re: cyclic dimension giving null values

Hi reddy,

i thought the same thing i am having 2.2 only. but it is available in straight table?

• Re: cyclic dimension giving null values

can someone tell me why it showing NULL values

• Re: cyclic dimension giving null values

even i changed the expression

If(Rank(count({<BW_FM_DT_YEAR={\$(=max(BW_FM_DT_YEAR))}>}LR_BW_VEH_ID)) <= 10,Count({<BW_FM_DT_YEAR={\$(=max(BW_FM_DT_YEAR))}>}LR_BW_VEH_ID))

in qlikview it works perfectly but in qlik sense showing null values also

• Re: cyclic dimension giving null values

hi Arul,

try using the expression this way -

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),

)

I kept only the first condition (since I have not added the variable extension) and got this result table. Then in the sort properties, pull up the 2nd column (if(VLossratio...) before the Pick(match(... ) and sort it descending.

Is this what you are expecting to get?

Hope this helps.

thanks,

Ajit

• Re: cyclic dimension giving null values

Hi Arul,

Try using the null value in the else part of if statement.

and then uncheck the show null value option.

Many Thanks

Karthik