table Ranking TOP 20%

[beginner91]

hello all,

i have a table and want to show the TOP 20% of it like:

Headline1 / Headline2 / Headline3

Name     /    Name      /     count of serveral numbers

i wanted to show the top 20% of the counted numbers.

can someone help me?

greetz

[beginner91]

?

[pradosh_thakur]

In the below example try this and it will give you 20% result

sum({<Name={"=Rank(Sum(mistakes))/Count(distinct total {1} Name)<=0.20"}>}mistakes)

[pradosh_thakur]

dimensions are Name and Number ... Measure is above. Create more data and check in the above example.

[beginner91]

when i write "=.... its green and does qlik sense see it as a expression?

[beginner91]

your expression isnt working.... can you maybe explain what you did? so i can understand it

[pradosh_thakur]

Hi

The expression is working and i have attached the screenshot . I have written the expression as per my understanding of the requirement. Please have a look. If this is not the requirement then may be others will be able to help you out.

sum({<Name={"=Rank(Sum(mistakes))/Count(distinct total {1} Name)<=0.2"}>}mistakes)

Please add some dummy data to your excel sheet data

 

Thanks

Pradosh

[beginner91]

thank you for your support. i think i did explain you a little bit wrong. check the excel sheet. i have 2 dimensions and 1 measure to count the mistakes.

[pradosh_thakur · Accepted solution]

count({<Name={"=Rank(count(mistakes))/Count(distinct total {1} Name)<=0.2"}>}mistakes)

[beginner91]

the expression in "..." is green writen. check my screenshots.

[pradosh_thakur]

I have sent you a qvf please refer that .. it would be same as that. There is nothing wrong with green, I have tested with your dummy data and it's working , not sure why it's not for you.

edit: the message is in moderation so not posted .