Re:only one value

[Chanty4u]

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

RE:Order

[#2]

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

[Chanty4u]

yes hirish...in my previous thread its used same exprsioon its wrks only onle value

[sunny_talwar]

Have you tried this?

Match(Only({1} Dimension),'1day','2days','3days','>3days')

[Chanty4u]

yeah sunny..

its wrkng for othr filters but not wrkng for days band filter...bar chart is nt reflectng

[#6 · Accepted solution]

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

[sunny_talwar]

Make sure State is unchecked:

[HirisH_V7]

Hi Suresh,

Check this,

Creating a custom sort order - The Qlik Fix! The Qlik Fix!

Hope this helps,

Hirish