Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pirotfab
Creator
Creator

FLOP in TCD

Hello,

I want to do two pivot table : the Flop 5 and the Top 5

here is my dimension : =if(Aggr(Rank( TRS ),post)<=5,post)

For the Top it's ok i have the 5 first post,

For the flop, it put me the 5 first post in ascending order, while i wish the 5 smaller TRS.

The différents betwenn this pivot table is sorting on expression

The top

The flop

Thanks

1 Solution

Accepted Solutions
mayankraoka
Specialist
Specialist

Use this 2 formulas:

dimension : =if(Aggr(Rank( TRS ),post)<=5,post)


dimension : =if(Aggr(Rank( -TRS ),post)<=5,post)


Regards,

Mayank

View solution in original post

2 Replies
mayankraoka
Specialist
Specialist

Use this 2 formulas:

dimension : =if(Aggr(Rank( TRS ),post)<=5,post)


dimension : =if(Aggr(Rank( -TRS ),post)<=5,post)


Regards,

Mayank

pirotfab
Creator
Creator
Author

Thanks

it's ok !