Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
albert_guito
Creator II
Creator II

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+
Anil_Babu_Samineni

Please post sample file
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful