topic Re: Set Analysis with variable in QlikView

Set Analysis with variable

lsteere01 — Mon, 06 Apr 2015 20:17:55 GMT

I posted a question earlier today and got a quick answer. This problem is similar but slightly different.

I need to subract the value in a variable (vLookback) from the value in the field [Days Old]. The following does not work:

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

Any ideas?

Thanks.

sunny_talwar — Mon, 06 Apr 2015 20:22:09 GMT

Why not do this on the other side of the expression:

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

a-b=c is equivalent to a = b + c, right?

Let me know if this doesn't work.

Best,

Sunny

lsteere01 — Mon, 06 Apr 2015 20:26:34 GMT

That is true but I'd like to streamline the set analysis if possible, to make it easier to read and possibly run a bit faster.

sunny_talwar — Mon, 06 Apr 2015 20:31:28 GMT

Try this in that case: (Havn't tested it, but it should work

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

Sunny

ramoncova06 — Tue, 07 Apr 2015 01:28:24 GMT

Or you could try with an intersection

Count({

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

<[Days Old]-$(vLookback)={"<=27393"}>

}distinct MRN)