topic Re: Using a variable in set anaysis. in QlikView

Using a variable in set anaysis.

lsteere01 — Mon, 06 Apr 2015 14:07:50 GMT

I'm trying to subtract a value stored in a variable (vLookback) from a fixed value (6574) in my set analysis but the syntax I'm using is not working. Any ideas where I'm going wrong?

Count({<[Days Old]={">=6574-$(vLookback)"}>}distinct MRN)

Thanks.

Re: Using a variable in set anaysis.

sunny_talwar — Mon, 06 Apr 2015 14:09:23 GMT

Try this maybe:

Count({<[Days Old]={">=$(=6574-$(vLookback))"}>}distinct MRN)

Best,

Sunny

Re: Using a variable in set anaysis.

Mon, 06 Apr 2015 14:14:58 GMT

try like this.....

Count({<[Days Old]={">={6574}-$(vLookback)"}>}distinct MRN)

Re: Using a variable in set anaysis.

lsteere01 — Mon, 06 Apr 2015 14:17:08 GMT

Seems to work. Thanks!

Re: Using a variable in set anaysis.

lsteere01 — Mon, 06 Apr 2015 14:17:54 GMT

Doesn't seem to work. Thanks.

Re: Using a variable in set anaysis.

sunny_talwar — Mon, 06 Apr 2015 14:18:21 GMT

Awesome! I am glad it worked.

Best,

Sunny