Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
Champion III
Champion III

Re:only one value

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

16 Replies
sunny_talwar

Not really sure what you mean when you say only one value its getting correct order? Which value? What are you trying to get?

Not applicable

when you say correct order, or you referring the the order of the bar charts?  if so, waht order do you want them in? 

Chanty4u
Champion III
Champion III
Author

when i select one value in listbox...its shwng  barchart bars in order lik 1day 2day 3day >3days wen i use match func in sort tab exprsion.....when i select diff value in list box the order again shwng to 1day >3days 2days 3days lik dat....

Chanty4u
Champion III
Champion III
Author

yeah..at dat time we chkd only in days chart..now its nt wrkng in weeks chart also

Not applicable

can you post your qvw?

it sounds like you want them in 1day 2day 3day >3days order

Chanty4u
Champion III
Champion III
Author

yes...i hve filter lik daysband with in dat ....i hve 1day 2day 3day >3days

Chanty4u
Champion III
Champion III
Author

days.png

order.png

i want the order always..... in same order like frst image

balrajahlawat
Champion
Champion

What about Dual() function??

While creating DaysBand at script, use dual() like this:

Dual & Exists – Useful Functions

HirisH_V7
Master
Master

Hi,

Is this you require,

Re sort.PNG

PFA,

HTH,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”