topic Re: set analysis expression in QlikView

set analysis expression

Mon, 27 Oct 2014 06:40:48 GMT

is this set expression is fine??

sum({$<Year = {$(vCurrentYear)},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Thanks

Re: set analysis expression

PrashantSangle — Mon, 27 Oct 2014 06:42:31 GMT

Hi,

use "

sum({$<Year = {"$(vCurrentYear)"},newDueIndicator={"3. Due Later"}>} [Undelivered Net value USD])

Regards

Re: set analysis expression

SunilChauhan — Mon, 27 Oct 2014 06:46:09 GMT

its seems ok to me.it should work

Re: set analysis expression

its_anandrjs — Mon, 27 Oct 2014 06:50:22 GMT

The SET expression looks ok or you can try

sum({$<Year = {" $(vCurrentYear) "},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Re: set analysis expression

Mon, 27 Oct 2014 06:53:05 GMT

not working,getting blank only.

Re: set analysis expression

SunilChauhan — Mon, 27 Oct 2014 06:53:57 GMT

you should try this one also

sum({$<Year = {$(=Year(Today()))},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Re: set analysis expression

ashfaq_haseeb — Mon, 27 Oct 2014 06:55:02 GMT

Try this

sum({$<Year = {"$(=vCurrentYear)"},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Regards

ASHFAQ

Re: set analysis expression

its_anandrjs — Mon, 27 Oct 2014 06:59:33 GMT

Or you can try

sum({$<Year = {' $(vCurrentYear) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

sum({$<Year = {' $(=YearStart( Today()) ) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

sum({$<Year = {' $(Year(vCurrentYear)) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Or may be you Year value is not in proper format please check that.

Regards,

Anand

Re: set analysis expression

jagan — Mon, 27 Oct 2014 07:03:34 GMT

Hi,

Try this expression

sum({$<Year = {2014}, newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

If you are getting value for this, then there is an issue with your varaible.

Regards,

Jagan.

Re: set analysis expression

adiarnon — Mon, 27 Oct 2014 07:08:12 GMT

hi,

check that in your expression of the variable -vCurrentYear

you have = before the expression

Re: set analysis expression

SunilChauhan — Mon, 27 Oct 2014 07:18:44 GMT

what is the problem with your expression.is it not working or just verifying

check with below points

1) as per Jagan's suggestion put 2014 and check wither your variable working fine

2) weither data available for Current Year in Raw data

3) try to put $(vCurrentYear) inside "" like " $(vCurrentYear)" in expression

4)see my suggestion above i mean Use =Year(today()) in place of variable

5) select Year from List box year and then check its working then try to use below

sum({<Year = {$(vCurrentYear)},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

6) check weither data available for combination Current Year and 3. Due Later

hope this helps

Re: set analysis expression

Mon, 27 Oct 2014 08:18:58 GMT

Hi,

sum({$<Year = {'$=(vCurrentYear)'},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Re: set analysis expression

Mon, 27 Oct 2014 08:50:51 GMT

Hi,

Try like below:

sum({$<Year = {'$(=$(vCurrentYear))'},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])