Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

View certain data

Good day,

I need to have a toggle - when not selected will display all the data in a straight table, however when selected to exclude the top 15% and bottom 15% of the calculated expressions in the straight table ... please assist and guide me in the right direction.

Thanks Chris

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You could try to get an acceptable view of your data with using the restriction tab of the straight table. This meant displaying the area between top and flop would be not possible but many other views are possible especially if variables will be used for the restiction values/borders.

If this isn't enough you will need to use calculated dimension like this one:

Aggr( If((Rank(Sum(Sales),1)-1) / Count(distinct total Product)< 0.50, 'A',

          If((Rank(Sum(Sales),1)-1) / Count(distinct total Product)< 0.75, 'B', 'C')),

          Product)

from the blog: Recipe for an ABC Analysis which provided many more ideas to these topic.

- Marcus