topic Re:only one value in QlikView

Re:only one value

Chanty4u — Mon, 04 Jan 2016 12:50:13 GMT

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

Re:only one value

sunny_talwar — Mon, 04 Jan 2016 12:52:54 GMT

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

Re:only one value

Mon, 04 Jan 2016 12:54:26 GMT

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

Re:only one value

Chanty4u — Mon, 04 Jan 2016 12:54:38 GMT

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....

Re:only one value

Chanty4u — Mon, 04 Jan 2016 12:55:32 GMT

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

Re:only one value

Mon, 04 Jan 2016 12:56:43 GMT

can you post your qvw?

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

Re:only one value

Chanty4u — Mon, 04 Jan 2016 12:58:46 GMT

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

Re:only one value

Chanty4u — Mon, 04 Jan 2016 13:09:58 GMT

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

Re:only one value

Anonymous — Mon, 04 Jan 2016 13:10:33 GMT

What about Dual() function??

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

Dual & Exists – Useful Functions

Re:only one value

HirisH_V7 — Mon, 04 Jan 2016 13:11:13 GMT

Hi,

Is this you require,

PFA,

HTH,

-Hirish

Re:only one value

Mon, 04 Jan 2016 13:13:45 GMT

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

Re:only one value

Chanty4u — Mon, 04 Jan 2016 13:17:13 GMT

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

Re:only one value

sunny_talwar — Mon, 04 Jan 2016 13:23:44 GMT

Have you tried this?

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

Re:only one value

Chanty4u — Mon, 04 Jan 2016 13:36:05 GMT

yeah sunny..

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

Re:only one value

Mon, 04 Jan 2016 13:43:30 GMT

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

Re:only one value

sunny_talwar — Mon, 04 Jan 2016 13:47:56 GMT

Make sure State is unchecked:

Re:only one value

HirisH_V7 — Mon, 04 Jan 2016 13:51:26 GMT

Hi Suresh,

Check this,

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

Hope this helps,

Hirish