Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rileymd88
New Contributor II

How to Restrict Expression by Another Expression

Hi,

I have a straight table which looks like this:

MarketMonthKPI Score (Calculated Dimension)Sales (Sum)
CanadaOct-1598%200
CanadaOct-1578%300
CanadaOct-1576%100
CanadaOct-1574%400
CanadaOct-1590%300
CanadaOct-1580%150
ChinaOct-1580%300
ChinaOct-1580%220
ChinaOct-1579%275
ChinaOct-1564%400
ChinaOct-1567%500
ChinaOct-1555%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:

MarketMonthKPI Score (Calculated Dimension)Sales (Sum)
CanadaOct-1578%300
CanadaOct-1590%300
CanadaOct-1598%200
ChinaOct-1567%500
ChinaOct-1564%400
ChinaOct-1580%300
1 Solution

Accepted Solutions

Re: How to Restrict Expression by Another Expression

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

comm193223.png


talk is cheap, supply exceeds demand
1 Reply

Re: How to Restrict Expression by Another Expression

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

comm193223.png


talk is cheap, supply exceeds demand
Community Browser