topic Variables Panel (Change Variables Order) in QlikView

Variables Panel (Change Variables Order)

microwin88x — Fri, 21 Mar 2014 13:49:42 GMT

Hello!

I wanted to know if there's any way to change the order of the variables showed in the panel

Do you know how could I do that?

Thank you!!!

Re: Variables Panel

julian_rodriguez — Fri, 21 Mar 2014 13:52:29 GMT

Just clik on the header of each column and the list will be organized alphabetically asending or descending.

Sólo hacer clic en el encabezado de cada columna organizará la lista alfabéticamente, de forma ascendente o descendente

Saludos

Re: Variables Panel (Change Variables Order)

stevedark — Fri, 21 Mar 2014 15:29:46 GMT

The natural order will always be the order you created the variables in. They can however be sorted alphabetically as Julian suggests.

If you wanted to make the natural order different I guess you would have to delete the variables and re-create them. This is almost certainly overkill though.

Steve

Re: Re: Variables Panel (Change Variables Order)

maxgro — Fri, 21 Mar 2014 22:03:07 GMT

it seems possible using an external files for variables with a sort column;

the natural order will be the order you set in the column of external excel files

Directory;

Tmp:

LOAD var as Variable,

exp as Expression,

sort

FROM

var.xlsx

(ooxml, embedded labels, table is Sheet1);

myTable:

NoConcatenate load * Resident Tmp order by sort;

For i = 0 to NoOfRows('myTable')-1

let var = peek('Variable', i, 'myTable');

let expr= peek('Expression', i, 'myTable');

set $(var) = $(expr);

Next i

let var=null();

let expr=null();

Re: Re: Variables Panel (Change Variables Order)

stevedark — Sat, 22 Mar 2014 07:06:17 GMT

With that approach you would still need to delete all the variables first before re-applying them - which wouldn't be much fun.

I'm not sure why you have the temporary table in your example - could you not put the sort order on the Excel load?

I use spreadsheets for variables quite a bit - it's a good way of sharing the same values between apps. A new variable will always appear at the bottom of the list though - regardless of where you put it in the sort order on the table.

- Steve

Re: Variables Panel (Change Variables Order)

maxgro — Sat, 22 Mar 2014 07:45:38 GMT

Yes you have to delete all variables but if all variables are in excel is simple to recreate them, just load and the order is the order you define in sort column

I know isn't not a very good solution but is the only one I know and I sometimes (few) use

Regarding excel sort I think is possible to sort only resident