topic Re: Problem using variables in QlikView

Problem using variables

Thu, 21 Jul 2016 08:30:42 GMT

I have declared the following variable

set vLateMTD = Sum({$<_LATE_MONTH_ID = {"$(=Max([_LATE_MONTH_ID]))" }>} LATE_ORDER_COUNT);

When I try this in a chart calculation its not returning any values.

Yet when I set the expression to be Sum({$<_LATE_MONTH_ID = {"$(=Max([_LATE_MONTH_ID]))" }>} LATE_ORDER_COUNT) its returning data.

I also tried (and this didn't work either)

set vLateMTD = Sum({$<_LATE_MONTH_ID = {"=$(=Max([_LATE_MONTH_ID]))" }>} LATE_ORDER_COUNT);

Thanks

Andy

Gysbert_Wassenaar — Thu, 21 Jul 2016 08:56:27 GMT

Try this:

LET vLateMTD = 'Sum({$<_LATE_MONTH_ID = {"$' & '(=Max([_LATE_MONTH_ID]))" }>} LATE_ORDER_COUNT)';

marcus_sommer — Thu, 21 Jul 2016 09:04:07 GMT

Another method would be: Re: Setting a variable in script... whereby if you want to declare many variables on this way an outside-storing of them might be more practically: Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!

- Marcus

Thu, 21 Jul 2016 09:04:49 GMT

That worked thanks.

Thu, 21 Jul 2016 09:47:49 GMT

Thanks for that, I have got it working using this method as well