Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
michal_durica
New 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
New Contributor III

Re: Day with maximum value

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

View solution in original post

6 Replies
sibusiso90
Contributor II

Re: Day with maximum value

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

Digvijay_Singh
Honored Contributor III

Re: Day with maximum value

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

vinieme12
Esteemed Contributor II

Re: Day with maximum value

please post a sample app

Re: Day with maximum value

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

michal_durica
New Contributor III

Re: Day with maximum value

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

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

michal_durica
New Contributor III

Re: Day with maximum value

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

View solution in original post