topic Re: column() in expression in QlikView

column() in expression

Wed, 12 Jun 2013 11:14:26 GMT

In a table (in a graph), i have two expressions, each of them have a calculated label.

In a third expression i use a formula like "=column(1) - column(2)".

If i add a column before the first one, i'll still have "=column(1) - column(2)" in the expression of the last column and that's not what i want.

How may i reference always the same cols (with not fixed but calculated label) in the expression without taking care of the order i set them in the table.

Re: column() in expression

sujeetsingh — Wed, 12 Jun 2013 11:16:28 GMT

Sorry didnt get you

Re: column() in expression

Wed, 12 Jun 2013 11:28:59 GMT

exemple :

i have a first column with a calculated label.

in another column (i call it TOTAL) i use column(1) to reference it.

If i move the first column in second position, column(1) in TOTAL will still reference the first column of the table.

How can i reference my col so that even if i move it, the reference in TOTAL will still be ok.

(That's a probleme of calculated label i can't use to reference the col)

Re: column() in expression

jagan — Wed, 12 Jun 2013 11:39:14 GMT

Hi,

Just instead of using Column() use Expression label, so even if you change the position of the expression you don't need to change the expression.

For Example:

First Expression:

Expression Label : Total Sales

Expression : = Sum(Sales)

Second Expression:

Expression = [Total Sales] + (Some Calculation)

Hope this helps you.

Regards,

Jagan.

Re: column() in expression

Wed, 12 Jun 2013 11:50:45 GMT

thank's for the answer.

My deal is : how can i do if the column has a calculated label and not a fixed one.

What i realy have in the label is :

='comptes mouv '&$(Annee variable)

Re: column() in expression

Wed, 12 Jun 2013 11:57:59 GMT

If the column label is calculated, u can still refer to it by name.

Let say the column name is

='Up to ' & var_delay & ' days'

In the expression u can refer to that column using syntax

$(='[Up to ' & var_delay & ' days]')

Re: column() in expression

Wed, 12 Jun 2013 12:01:09 GMT

It would be $(='[comptes mouv ' & $(Annee variable)]')

Re: column() in expression

jagan — Wed, 12 Jun 2013 12:02:46 GMT

Hi,

Please find attached file for solution.

Regards,

jagan.

Re: column() in expression

Wed, 12 Jun 2013 12:04:30 GMT

Perfect !!!

Hard to guess 😉

Thank's a lot, it's a huge help.

Re: column() in expression

Wed, 12 Jun 2013 12:08:20 GMT

$(='[comptes mouv ' & $(Annee variable)&']')

to be exact.

But that's it.