topic Variables in Column Label not working. in QlikView

Variables in Column Label not working.

Anonymous — Fri, 13 Jun 2014 16:48:39 GMT

Hello All,

I have a dynamic label expression that works when It is dropped as is into a straight table column label like so:

=Date(MonthStart(AddMonths(Max((RDateofPmnt),-11),'YYYY-MM'))

However, when I use variables to store the expression, broken in 2 so I can insert a column specific offset number, it does not

work:

$(=(var1 & '-11' & var2))

I have tried several alternatives but no luck.

When I use a similar tactic for expressions and conditions, it does work.

Just the Label expression does not.

Thanks for any help.

Tim Roy

Gysbert_Wassenaar — Fri, 13 Jun 2014 16:51:36 GMT

Variables containing expressions need to be dollar-expanded:

=$(var1) & '-11' & $(var2)

Anonymous — Fri, 13 Jun 2014 16:54:09 GMT

But they are not valid expressions until the strings are combined, just pieces

Gysbert_Wassenaar — Fri, 13 Jun 2014 16:58:06 GMT

Oh well, no idea in that case. But try creating a variable with a parameter:

var1: Date(MonthStart(AddMonths(Max((RDateofPmnt),$1),'YYYY-MM'))

label: =$(var1(-11))

Anonymous — Fri, 13 Jun 2014 17:08:02 GMT

Thanks for the idea, that works.

I still wonder why it didn't work the other way.

I worked for Expressions and Conditions, just not Labels

Anyways, onward ..... and

Regards