topic Re: set analysis help in QlikView

set analysis help

Fri, 30 Jan 2015 09:13:20 GMT

Hi All

Need a help in set analysis.

we have a scenario

Table1:
Load * inline

[

D1 , Key

5/1/2015 , A

6/1/2015, B

7/1/2015, C

];

And we have a calendar linked which has all dates.

Need count(key) where (date selected - D1)>5

Please help with the set analysis expression for this.

Suppose date selected is 11/1/2015, count of key is 1, as

11-5=6 for A

11-6 = 5 for B

11-7 = 4 for c

Only for A, the difference is >5.

Thanks.

PrashantSangle — Fri, 30 Jan 2015 09:17:34 GMT

Hi,

Try like

count(if(interval(date_SelectedField-D1,'D')>5),key)

Regards

its_anandrjs — Fri, 30 Jan 2015 09:28:46 GMT

Hi,

Try this expression

Count(if(interval(GetFieldSelections( YourCalendarDate )-D1,'D') > 5,Key))

Regards

Anand