topic Re: Varibale in QlikView

Varibale

upaliwije — Sun, 07 Feb 2016 10:03:54 GMT

I have created a variable as follows

V3month=(PAID_MONTH='May,Jun,Jul')

and use it in a set expression in the following way

SUM({<$(V3month)>}CRE_PAID_AMOUNT)/3

But I do not get the results . Have i made any errors in creating variable or expression. Pls help

marcus_sommer — Sun, 07 Feb 2016 10:33:22 GMT

Try:

set V3month = "PAID_MONTH = {'May','Jun','Jul'}";

- Marcus

upaliwije — Sun, 07 Feb 2016 13:46:16 GMT

Thanks

Where should I place your script ? when I put it in data variable overview It does not work

marcus_sommer — Sun, 07 Feb 2016 13:52:39 GMT

This would be within the load-script - by defining it within the variable-editor you write:

PAID_MONTH = {'May','Jun','Jul'}

- Marcus

upaliwije — Sun, 07 Feb 2016 13:58:56 GMT

Tks

However when I put it in Variable over view it is not working

this part gets underlined in red {'May','Jun','Jul'}

What could be reason please

marcus_sommer — Sun, 07 Feb 2016 14:11:27 GMT

The syntax-interpreter tried to interpret it as expression but it's only an expression-part therefore you could ignore the red underlines.

- Marcus

upaliwije — Sun, 07 Feb 2016 14:14:01 GMT

Thanks for you expalnation