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: 
cafcptg2011
Creator
Creator

ranking problem

Hi,

How do I get the ranking value from a pivot table to text object, to understand better the my problem I have attached a qvw file .

Could someone please help me on this.

Thanks in advance,

CAFC

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try:

=max(if(aggr(sum(Value),ARTICLE) = $(vT), aggr(rank(sum(Value)),ARTICLE)))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try:

=max(if(aggr(sum(Value),ARTICLE) = $(vT), aggr(rank(sum(Value)),ARTICLE)))


talk is cheap, supply exceeds demand
cafcptg2011
Creator
Creator
Author

it works!!

thank u very much

cedric