Variable

[upaliwije]

Hi

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

[0li5a3a]

try this:

SET vYear={'2015;2016'}

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

[Anonymous]

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

[upaliwije]

It does not work

[upaliwije]

I have tried it does not work

In fact

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

[ahaahaaha · Accepted solution]

Hi,

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

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

Result

Look attached file.

Regards,

Andrey

[Anonymous]

Try this:

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

[Anonymous]

Try this

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

or

vYear=max(year)-1

vCurrentYear=max(Year)

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

[sanjay006]

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.