topic Script Expression help in QlikView

Script Expression help

Mon, 18 Jul 2011 13:45:40 GMT

Hello

Simply put I would like to set the expression below as TKGF in the script:

SUM({$ <VAL = {"SKGF","PKGF"}>}Data)

SKGF (standard KG Forecast) and PKGF (Promotional KG Forecast) are fields in the VAL dimension.

The expression above works to give me the required amount in a chart expression but QV doe not like the Syntax in the script.

Please can you explain what is needed.

Many thanks

Gareth

pat_agen — Mon, 18 Jul 2011 13:57:51 GMT

hi,

you cannot use set analysis - th epart of your expression found within the curly brackets - in the script.

use some text as below:

sum(if(match(VAL,'SKGF','PKGF')>0,Data) as fldSummedData

Tue, 09 Aug 2011 09:37:49 GMT

Thanks Pat