How to Calculate Count of TOP/Bottom records.

[Anonymous]

Hi Everyone,

I am new to qlikview & need your help.

I wanted to count of records which are < 31%. I have attached test QVW.

I wanted to show the count for records which are <31% in Text object. How to achieve this?

Thank you in advance.

[trdandamudi · Accepted solution]

Based on your above table chart, I think your result should be 3 in the text object. If that is the case then please use the below expression in a text object which will give you a count of 3:

=Sum(Aggr(If(count(Tons)/count(TOTAL(Tons)) < 0.31,1,0),Material))

Hope this helps...

[Anonymous]

Hi Thirumala,

Thank you, it worked:)

[trdandamudi]

Awesome... Glad to hear that....