topic Refer to previous column name in QlikView

Refer to previous column name

Tue, 25 Jun 2013 12:13:48 GMT

Dear Ladies and Gentlemen,

I looking for a solution to refer to the column name of a column before.

I would like to have the label of the first column based on the second column (depending which value I've choosen)

Thank you very much for your help in advance,

Philip Sanders

Re: Refer to previous column name

alexandros17 — Tue, 25 Jun 2013 12:15:17 GMT

Look for above and previous key word ... (search in the guide)

Re: Refer to previous column name

Tue, 25 Jun 2013 12:17:48 GMT

Hi,

Please type in your column name as it is in the expression and in case your column name has space in between then type in your column name in square brackets [].

Thanks,

Re: Refer to previous column name

jonathandienst — Tue, 25 Jun 2013 12:19:43 GMT

I do not know of any way to get that column name, but if you need to use the column in another expression, you could use the column number instead. eg Column(1) + Column(2)

But it seems like you want to sum the column in your screenshot. You cannot to the best of my knowledge use aggregation functions against other columns in the table. Only simple row arithmetic.

Hope that helps

Jonathan

Re: Refer to previous column name

Tue, 25 Jun 2013 12:20:40 GMT

Dear Alexandors17,

Dear umeshajadhav

thank you very much for your super-fast help. I appreciate this a lot.

I've taking a look on the previous and above function but do not see how this can work in this example.

My first Expression should have the column-name of the second column - depending on the current selected expression in the cycle group.

Re: Refer to previous column name

Tue, 25 Jun 2013 12:21:59 GMT

I just only want to use the name of the second expression (based on the current selection in the cycle group)

for the first expression.

Re: Refer to previous column name

alexandros17 — Tue, 25 Jun 2013 13:27:47 GMT

Ok, it's clear now,

so try this:

in the label expression for column1 write

=if(GetCurrentField(aaa)='Cod','uno','due')

where

- aaa is your cyclic dimension (never mind the error it warns, it works!)

- 'uno' is the label expression when condiction is satisfied

- 'due' is the label expression when condiction is not satisfied (one of the two must be equal to the label of the second column

Hope it may help.