Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Simple Qlik Chart

 

Hi all, 

Attached is the chart i have tried in Qlik Sense. 

image.png

What i want to be able to do is to be able to customize the PCI ranges at the left side without hard coding the ranges. This means when i filter , for example PCI from $200 to $1,500. The first row might show something like >= $200 to <=$1,500. Basically to be able to define my own ranges and to display it in the table. Please  help if you have any idea.

(An idea i had was to create columns with no values and then put them as dimensions and then use the PCI range to toggle around. I am unsure if it is possible)

Thank you for your time. 

 

Labels (1)
2 Replies
Highlighted
Creator II
Creator II

Re: Simple Qlik Chart

You can use a class() function for the PCI dimension but the interval has to be fix for both intervals (0-100, 100-200, ...). If you need to user different ranges (0-200, 200-1500, ...) you have to do it in the script. Using an intervalmatch you can get it.
Ag+
Highlighted

Re: Simple Qlik Chart

Please post sample file
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)