Discussion Board for collaboration on QlikView Scripting.
Need a help in set analysis.
we have a scenario
Table1: Load * inline
D1 , Key
5/1/2015 , A
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.
Go to Solution.
Try this expression
Count(if(interval(GetFieldSelections( YourCalendarDate )-D1,'D') > 5,Key))