Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
su88rao
Partner - Contributor III
Partner - Contributor III

Second if condition not working within expression in qliksense

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

0 Replies