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

sorting

Hi there,

I have a dynamic calculated dimensio(Age band)n in bar chart.The values are N/A, 1 to 30 days, 31 to 90 days,  91 to 180 days, 181 to 365 days, 366 days plus based on Age field. N/A will capture -ve values of Age. Iwant to order the data in bar chart based on ageband in the same way mentioned above. But unable to sort by using sort tab options.  Can any one help? Good thing is the ageband values are fixed. No additional values will be added.

10 Replies
MarcoWedel

Hi,

maybe this helps:

Custom Filter(unusual range)

This solution uses the dual function to create underlying numerical values for unequal sized buckets so that sorting needs no special sorting expressions.

regards

Marco