topic Re: expression in variable in QlikView

expression in variable

Mon, 30 Jul 2012 14:39:11 GMT

hi there,

i am using the same expression in multiple charts and want to store the expression simply in a variable and then just reference the variable in the expression of the chart. is that feasible ? I tried vVarName, = vVarName and = $(vVarName), but nothing brought up the result.

Any idea how this could work ?

Thanks in advance.

Re: expression in variable

Mon, 30 Jul 2012 14:43:50 GMT

try with sinply vVarName where vVarName is declared as: =Sum(Value)

Re: expression in variable

Mon, 30 Jul 2012 14:47:33 GMT

It seems to work if i have only one record in my chart selected. But having nothing selected the expression returns NULL....

Re: expression in variable

Mon, 30 Jul 2012 14:50:17 GMT

OK, let me get my crystal globe and guess your structure, data and what you want to achieve...

Re: expression in variable

Mon, 30 Jul 2012 15:02:08 GMT

you dont need a chrystal globe - its simple:

a) you have a table

Initiative	Actual	Country	Unit
Initiative A	100.000	US	$
Initiative B	50.000	CAN	$
Initiative C	125.000	EUR	$
Initiative D	24	EUR	%
Initiative E	2	EUR	#

b) you have a pivot chart with Initiative & Country as Dimensions

c1) you have as Expression (in the pivot table):

= if(Unit = '%', num(Actual, '# ##0%'), if (Unit = '#', num(Actual, '#0'), num(Actual, '## ##0.00') ))

--> works fine

c2) you have the expression above in variable and the variable in the chart expression, then it only works when you have one record of the chart selected.

chrystal clear ?

Re: expression in variable

Mon, 30 Jul 2012 15:12:25 GMT

Use

if(Unit = '%', num(Actual, '# ##0%'), if (Unit = '#', num(Actual, '#0'), num(Actual, '## ##0.00') ))

in your variable (without "=") and use

=$(vVariable)

in chart expression

Re: expression in variable

Mon, 30 Jul 2012 15:17:48 GMT

Merci!