topic Re: help with variable in script in QlikView

help with variable in script

hopkinsc — Fri, 14 Jun 2013 12:17:27 GMT

Hi all,

I have the following variable

NUM(SUM({<sam_type={ALLOCATION}, sam_fiscal_year = {'$(=CurrentFiscalYear)'} >} sam_volume), '#,##0.00')

This works if i create it in the Variable Overview, but if i try and create it in the script instaed i get an internal error when i look at it in the variable overview after a reload.

i am trying this

SET vAllocation_FullYear = NUM(SUM({<sam_type={ALLOCATION}, sam_fiscal_year = {'$(=CurrentFiscalYear)'} >} sam_volume), '#,##0.00')

Does anyone know what i am doing wrong please?

Re: help with variable in script

Gysbert_Wassenaar — Fri, 14 Jun 2013 12:27:52 GMT

The problem is that Qlikview will dollar-expand $(=CurrentFiscalYear) and try to evaluate it. That returns an error which then ends up in the variable.

Try:

SET vAllocation_FullYear = NUM(SUM({<sam_type={'ALLOCATION'}, sam_fiscal_year = {'^(=CurrentFiscalYear)'} >} sam_volume), '#,##0.00');

LET vAllocation_FullYear = replace('$(vAllocation_FullYear)','^','$');

edit: works for me. see attached qvw

Re: help with variable in script

hopkinsc — Fri, 14 Jun 2013 12:55:08 GMT

Hi Gysbert,

That doesnt work unfortunately, If i look at the variable in the variable overview window i see the following..

NUM(SUM({<sam_type={' 'ALLOCATION' '}, sam_fiscal_year = {' '$(=CurrentFiscalYear)' '} >} sam_volume), ' '#,##0.00' ')

Note: i have put spaces above so you can see they are 2 single quotes throught the expression.