topic Re: Variable in QlikView

Variable

upaliwije — Tue, 16 May 2017 07:05:27 GMT

I have created the following variable in my QV doc

vYear=YEAR={'2015','2016'}

and I have written the below expression using the above variable

sum({$<DESCRIPTION = {GROSS_PREMIUM},YEAR=$(vYear)>}[ACTUAL])

But result is blank. Pls help me to correct my above expression

Re: Variable

0li5a3a — Tue, 16 May 2017 07:25:25 GMT

try this:

SET vYear={'2015;2016'}

sum({$<DESCRIPTION = {GROSS_PREMIUM},$(vYear)>}[ACTUAL])

Re: Variable

Anonymous — Tue, 16 May 2017 07:32:09 GMT

Hi Upali,

is GROSS_PREMIUM a field or text? If it is a field, present like this this - [GROSS_PREMIUM]. If it is text, like this - 'GROSS_PREMIUM'.

try this:

SUM({$<DESCRIPTION={'GROSS_PREMIUM'},YEAR={'=$(=$(vYear))'}>}[ACTUAL])

Hope this helps

Re: Variable

upaliwije — Tue, 16 May 2017 07:39:39 GMT

It does not work

Re: Variable

upaliwije — Tue, 16 May 2017 07:40:49 GMT

I have tried it does not work

In fact

SUM({$<DESCRIPTION={'GROSS_PREMIUM'}>}[ACTUAL]) works well Once I add vYear it does not work

Re: Variable

ahaahaaha — Tue, 16 May 2017 07:41:03 GMT

Hi,

SET vYear={'2015','2016'};

Sum ({<Year=$(vYear)>}Value)

Result

Look attached file.

Regards,

Andrey

Re: Variable

Anonymous — Tue, 16 May 2017 07:43:52 GMT

Try this:

SUM({$<DESCRIPTION={'GROSS_PREMIUM'},YEAR={$(vYear)}>}[ACTUAL])

Re: Variable

Anonymous — Tue, 16 May 2017 07:50:16 GMT

Try this

sum({$<DESCRIPTION = {GROSS_PREMIUM},YEAR={2014,2015}>}[ACTUAL])

vYear=max(year)-1

vCurrentYear=max(Year)

sum({<YEAR={$(vYear),$(vcurrentYear)}>}Sales)

Re: Variable

sanjay006 — Tue, 16 May 2017 07:52:38 GMT

sum({$<DESCRIPTION = {GROSS_PREMIUM},YEAR="$(vYear)">}[ACTUAL])

It might be possible that your variable is in string and you are passing the number in your set.