topic Re: sorting in multi box DISREGARDING state in QlikView

sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 05:40:33 GMT

Hi,

this is my problem:

There is a text field containing the quarters of each year (e.g. '2015 Q1'). I want to choose the Quarter from a drop down multi-box. But it is impossible to keep the quarters in the right order. The selected one is always on top, even though sorting order by state is ticked off.

Is this a bug or a feature? Any ideas?

Keep Qliking

Michael

Re: sorting in multi box DISREGARDING state

sunny_talwar — Fri, 29 Apr 2016 05:42:59 GMT

On the sort tab, can you make sure that 'state' option is unchecked?

Re: sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 05:45:34 GMT

as I said...it is ticked off:

Re: sorting in multi box DISREGARDING state

sunny_talwar — Fri, 29 Apr 2016 05:47:34 GMT

Sorry, I missed that. Can you try checking Numeric Value also (while keeping Text)

Re: sorting in multi box DISREGARDING state

marcus_sommer — Fri, 29 Apr 2016 06:48:03 GMT

Hi Michael,

maybe this is an alternative for you: Building a nicer, dynamic QlikView multibox The Qlik Fix!

- Marcus

Re: sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 07:23:20 GMT

same result 😞

Re: sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 07:24:42 GMT

Very nice hint and I like Barry's demo app.

But actually it suffers from the same problem: The selected values are always at the top even with sort by status is ticked off.

Re: sorting in multi box DISREGARDING state

marcus_sommer — Fri, 29 Apr 2016 07:42:20 GMT

I have checked this even with various expressions like: =aggr(concat({1} distinct Region, ',', Region), Region) but the selected values are always on the top and break the sorting. Therefore it's a "feature".

An alternatively (which I use quite often) for you might be to use listboxes with a container instead of a multibox.

- Marcus

Re: sorting in multi box DISREGARDING state

Anonymous — Fri, 29 Apr 2016 07:52:35 GMT

in the sort tab define this Expression

only({1}QUARTER)

Re: sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 07:59:31 GMT

really strange result in my model, it breaks the alphabetical order AND sorts by status

Re: sorting in multi box DISREGARDING state

marcus_sommer — Fri, 29 Apr 2016 08:08:06 GMT

For me it didn't work and are there more then one selected value it should in general fail. Which qv release and which client do you used for it (my is QV 11 SR12 with desktop client)?

- Marcus

Re: sorting in multi box DISREGARDING state

Anonymous — Fri, 29 Apr 2016 08:13:46 GMT

I used QV 12

for my customer I had the same Problem with QV 11 SR12 and I used another formula

I am currently not at customer site and I donot have QV11 SR12 available.

So you may test another Expression

selecting more than 1 value will not work with only

Re: sorting in multi box DISREGARDING state

michael_klix — Fri, 29 Apr 2016 08:44:55 GMT

just to understand the logic behind.... what does the formula in plain words?

Re: sorting in multi box DISREGARDING state

Anonymous — Fri, 29 Apr 2016 08:58:02 GMT

the Point is that with {1} takes all values of the specified field regardless of any selections

instead of only you can use max

only ({1}QUARTER) works also when more than 1 quarter is selected

I used QV 12. But my customer had the same expectation with QV 11 SR12. But I cannot give

you the Expression for QV 11 (it may differ from the above Expression)