Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unique Visits

Hi All,

I have a requirement that i have to Count Distinct Students Attended in a Month, Next month and so on

so IF one student was attending the whole year it would be 12 Attends, Even if he was coming to school everyday?

3 Replies
anbu1984
Master III
Master III

Load StudentID,Year(DateAttended) As Year,Count(DISTINCT Month(DateAttended)) Group By StudentID,Year(DateAttended);

Load StudentID,Date#(DateAttended,'DD/MM/YYYY') As DateAttended Inline [

StudentID,DateAttended

100,1/1/2015

100,1/2/2015

100,2/2/2015

101,1/2/2015 ];

Not applicable
Author

Hi,

i want to use the code in Front End Expression on a straight table.

Regards.

anbu1984
Master III
Master III

In Front End,

Use StudentID,Year As dimension and Use Count(Distinct Month) as expression

Load *,Year(DateAttended) As Year,Month(DateAttended) As Month;

Load StudentID,Date#(DateAttended,'DD/MM/YYYY') As DateAttended Inline [

StudentID,DateAttended

100,1/1/2015

100,1/2/2015

100,2/2/2015

101,1/2/2015 ];