Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit the value...

Hello,

Below is my sample data .

Region     Cost

NA           100000

LATAM       90000

EMEA        60000

APAC        40000

I want to display cost by Region in bar chart but should have an option to toggle between regions with cost more than 75 k and regions with cost less than 75 k.

Is this doable at all ?

Thanks much.

2 Replies
sunny_talwar

Sure thing. May be using a variable called vVar, create an expression like this:

If(vVar = 1, Sum(Cost), If(Sum(Cost) > 75000, Sum(Cost)))

sunny_talwar

Sample attached