topic Finding common values in QlikView

Finding common values

naveenchellaara — Fri, 14 Feb 2014 11:19:46 GMT

Hi,

We are having a requirement where we need to display the count of students enrolled in a camp. We have two time periods in the report. Current time period (selected by the user) and the previous time period ( time period selected by the user - 1 year). We need to find students who have their status as enrolled in both time period.

If the user selects Jan 2014 as the current time period, then the previous time period will be Jan 2013.

Set 1 - Students enrolled in Jan 2014.

Set 2 - Students enrolled in Jan 2013.

I need to find the intersection of the two sets

Thanks in Advance

Naveenchellaaraam.D

Re: Finding common values

vikasmahajan — Fri, 14 Feb 2014 11:37:15 GMT

This is possible please request you to put some dummy records in excel for 4,5 students , some thing like wise comparison you want .

Vikas

Re: Finding common values

sivarajs — Fri, 14 Feb 2014 12:33:13 GMT

Count({<year={">=$(=Max(year)-1)<=$(=Max(year))"}>} StudentID)

Re: Finding common values

Gysbert_Wassenaar — Fri, 14 Feb 2014 15:06:40 GMT

Something like this:

count({<Status={'Enrolled'},Month={'$(=only(Month)'},Year={'$(=only(Year))'},StudentID=p({<Status={'Enrolled'},Month={'$(=only(Month)'},Year={'$(=only(Year)-1)'}>}StudentID)>}distinct StudentID)