Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Refer to previous column name

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)

Screenshot.png

Thank you very much for your help in advance,

Philip Sanders

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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,

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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.

Not applicable
Author

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.

alexandros17
Partner - Champion III
Partner - Champion III

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.