Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have small issue...
i hve filter like
status:
open
closed
fix
and bar chart i hve bars like
1Day'
2Day
3Day
>3days
issue is...only one value its getting correct order...not for all values? please chk below my prevoius thread for ref
i would suggest an inline load of those values in the order you want and then on the sort tab, sor in load order
would this niot work?
it looks like right now it is sorting based on the value select as your filter - you want the sort to be statice regardless of any selections
yes hirish...in my previous thread its used same exprsioon its wrks only onle value
Have you tried this?
Match(Only({1} Dimension),'1day','2days','3days','>3days')
yeah sunny..
its wrkng for othr filters but not wrkng for days band filter...bar chart is nt reflectng
try something along the lines of
Load * Inline [
Aging Bucket, SortOrderAgingBucket
Current, 1
1-30, 2
31-60, 3
61-90, 4
91-180, 5
Over 180, 6
]
and thenn in the sort of the object, sort by expression
SortOrderAgingBucket
just make sure you have a link from this table to the table with data
Make sure State is unchecked:
Hi Suresh,
Check this,
Creating a custom sort order - The Qlik Fix! The Qlik Fix!
Hope this helps,
Hirish