Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
michal_durica
Contributor III
Contributor III

Day with maximum value

I would like to show table where it will one (the highest value)and its date within each month.

The problem is that I calculate aggr function on month year level, but when I would like to show maximum date within month which is lower level than month year it will fail.

The other task is not to show other dates where maximum value isn't.

In the printscreen below you can see within pivot table I am able to do it this way but I am unable to hide those non maximum dates..

1 Solution

Accepted Solutions
michal_durica
Contributor III
Contributor III
Author

if(aggr(rank(Calculation),Month_Year,Date)<=1,Calculation)

View solution in original post

6 Replies
sibusiso90
Creator III
Creator III

Can you send a sample app, but I am sure you can do it by hiding nulls and zero values.

Digvijay_Singh

You have values in the other two expressions, Exposure low and settlement, do you want to hide those values as well?

vinieme12
Champion III
Champion III

please post a sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
avinashelite

Share the sample app with the required output so that it will help us to understand

michal_durica
Contributor III
Contributor III
Author

I already fixed it: by combination of function rank and aggr

if(aggr(rank(calculation),Month_Year,Datum)

michal_durica
Contributor III
Contributor III
Author

if(aggr(rank(Calculation),Month_Year,Date)<=1,Calculation)