topic Re: Set Analysis Expression not Working in QlikView

Set Analysis Expression not Working

Sat, 20 Jul 2013 04:25:31 GMT

Hi All,

I'm trying to create a Set Analysis expression in the edit script using a variable as shown below:

SET vRevenue = "Sum({$<FiscalYear = {$(=max(FiscalYear))} >}Revenue)";

When i access the vRevenue variable in the chart,i'm getting an internal error as shown below:

Sum({$<FiscalYear = {'(internal error)'} >}Revenue)

The same is working fine when i create a variable in the variable overview and i want to create it in the edit script. Please suggest that how to overcome this error.

Thanks in Advance.

Regards,

Desmortes.

Re: Set Analysis Expression not Working

Sokkorn — Sat, 20 Jul 2013 04:34:02 GMT

Hi Desmortes,

Did you try this yet: =$(vRevenue)

Regards,

Sokkorn

Re: Set Analysis Expression not Working

Gysbert_Wassenaar — Sat, 20 Jul 2013 06:28:53 GMT

Try: LET vRevenue = 'Sum({$<FiscalYear = {$' & '(=max(FiscalYear))} >}Revenue)';

Or this:

SET vRevenue = Sum({$<FiscalYear = {@(=max(FiscalYear))} >}Revenue);

LET vRevenue = replace('$(vRevenue)','@','$');