Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

oscarmqz
Contributor III

Take nth row from Aggr?

Hi All,

I have this aggr function

aggr(count(XXX)/sum(YYY),Date)

COUNT(XXX)/SUM(YYY) is calculating acheivement percent, what I'm looking for, is to get the date when it reached 98%, firstsortedvalue is not working (at least in the way I'm using it) because it is giving me the top date (equal to 100%). How can I limit the result of aggr only to be those >=98% so I can use firstsortedvalue.

Or if you have any other solution I'd really appreciate it, thanks in advance!

Tags (4)
2 Replies
Not applicable

Re: Take nth row from Aggr?

Could you share your qvw or some sample data?

oscarmqz
Contributor III

Re: Re: Take nth row from Aggr?

Here it is, I'm trying the formula in the blue text box

Community Browser