Second if condition not working within expression in qliksense

su88rao — Wed, 03 Jul 2019 08:47:48 GMT

Hi,

I am trying to get the sum of a column based on calculated dimension, i want to restrict the value to top 5 based on category.

i m not able to restrict it. the output is displaying all the values. also and and/or function inside expression is not working out.

can anybody help me out here and suggest where i am going wrong.

below is the expression i am trying to in corporate

IF(Aggr(Rank(-SUM({<DateID={"<=$(=Max(DateID))>=$(=Max(DateID)-3)"},Date=>}abc),4),categ,id)<=5,
sum({<DateID={$(=max(DateID)-0)},Date=>}cal),

IF(aggr(SUM({<DateID={"<=$(=Max(DateID))>=$(=Max(DateID)-3)"},Date=>}abc), abc)=0 or
Aggr(Rank(SUM({<DateID={$(=max(DateID)-0)},Date=>}cal),4),categ,id)<=5,
sum({<DateID={$(=max(DateID)-0)},Date=>}cal)))

Thanks & Regards

Suraj Rao

topic Second if condition not working within expression in qliksense in App Development

Second if condition not working within expression in qliksense