Straight table: create a dimension as a top 10

[zweigzweig]

Hi everyone.

I would like to modify this formula (set analysis) in a straight table:
Count(Distinct {<Center = {'Center_01'}>} ID_AS)

To show only the first 10 values (Top10).

My straight table have 3 Columns:
|     Product_Des     |     Product_Ref     |     The Formula I want to do     |

Please, Can anyone help?
Thank you.

[StarinieriG]

Hi,

you could do it inside dimension settings. Try to look here https://help.qlik.com/en-US/sense-developer/September2019/Subsystems/Mashups/Content/Sense_Mashups/C...

[Vegar]

Here is an even better link. 

https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Tabl...

Scroll down to Limitation at the dimension settings section.

[sunny_talwar · Accepted solution]

If Product_Des and Product_Ref are always one to one, then you can do this using set analysis

Count(DISTINCT {<Center = {'Center_01'}, Product_Des = {"=Rank(Count(DISTINCT {<Center = {'Center_01'}>} ID_AS)) < 11"}>} ID_AS)

Alternatively, you can do this using an if statement

If(Rank(TOTAL Count(DISTINCT {<Center = {'Center_01'}>} ID_AS)) < 11, Count(DISTINCT {<Center = {'Center_01'}>} ID_AS))

[zweigzweig]

The second opcion works fine.

Thank you so much!