Hi all,
Attached is the chart i have tried in Qlik Sense.
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.
You won't be able to to custom set PCI ranges that will show in a table in the front-end without hard-coding them.
The data you're showing in your table/chart is shown by a measure based on the connection of the data to your dimensions.
Because your PCI range dimension is shown as a string you won't be able to set custom ranges. (Unlike numerical values, where you can use <, >, = when making a selection, but still can't set custom PCI ranges that'll show in the table)