How to Restrict Expression by Another Expression

rileymd88 — Fri, 27 Nov 2015 10:04:19 GMT

Hi,

I have a straight table which looks like this:

Market	Month	KPI Score (Calculated Dimension)	Sales (Sum)
Canada	Oct-15	98%	200
Canada	Oct-15	78%	300
Canada	Oct-15	76%	100
Canada	Oct-15	74%	400
Canada	Oct-15	90%	300
Canada	Oct-15	80%	150
China	Oct-15	80%	300
China	Oct-15	80%	220
China	Oct-15	79%	275
China	Oct-15	64%	400
China	Oct-15	67%	500
China	Oct-15	55%	100

I would like to restrict the KPI Score in this straight table which will also have many other records and Market&Month combinations to only take into consideration the top 3 by sales for each Market&Month combination

For example:

I would expect to see only the following records showing up in the straight table/KPI Score only:

Market	Month	KPI Score (Calculated Dimension)	Sales (Sum)
Canada	Oct-15	78%	300
Canada	Oct-15	90%	300
Canada	Oct-15	98%	200
China	Oct-15	67%	500
China	Oct-15	64%	400
China	Oct-15	80%	300

Re: How to Restrict Expression by Another Expression

Gysbert_Wassenaar — Sat, 28 Nov 2015 11:34:59 GMT

You can use Dimension Limits for this like done for the second dimension in the example below:

topic Re: How to Restrict Expression by Another Expression in QlikView

How to Restrict Expression by Another Expression

Re: How to Restrict Expression by Another Expression