topic Re: Sorting selections in straight table in QlikView

Sorting selections in straight table

_rohitgharat — Mon, 13 Jul 2015 05:47:00 GMT

Hi Friends,

I have made a bucket using straight table as you can see in the attachment. The problem i am facing is when i click on any one of the bucket for e.g '5-6 Days' then the sequence gets changed .I don't want the sequence to be changed but the selections to be happened. Please suggest if there is any solutions.

Following is the bucket:

After Selection sequence is changed:

Re: Sorting selections in straight table

lironbaram — Mon, 13 Jul 2015 05:56:00 GMT

in the sort section

you can use an expression

assuming you have a field called sort order

use something in the lines of

max({1} sortorder)

Re: Sorting selections in straight table

Kushal_Chawda — Mon, 13 Jul 2015 06:14:08 GMT

Create your bucket in script using Dual fucntion

Re: Sorting selections in straight table

_rohitgharat — Mon, 13 Jul 2015 06:15:41 GMT

Thanks Liron,

Can we also maintain background colour because when i

select the background colour also disappears for other buckets except the

selected bucket.?

On Mon, Jul 13, 2015 at 11:26 AM, Liron Bra'am <qcwebmaster@qlikview.com>

Re: Sorting selections in straight table

_rohitgharat — Mon, 13 Jul 2015 06:18:41 GMT

can you show me the example?

On Mon, Jul 13, 2015 at 11:44 AM, Kush141087 <qcwebmaster@qlikview.com>

Re: Sorting selections in straight table

Kushal_Chawda — Mon, 13 Jul 2015 06:50:10 GMT

I can give you example , but that may not be suitable for your scenario. It will be better if you can share your sample app.

Re: Sorting selections in straight table

lironbaram — Mon, 13 Jul 2015 08:07:32 GMT

yes you can , once again using set analysis in the expression

but then how will the user now he selected something ?

attach is an example