topic Re: Unique Visits in QlikView

Unique Visits

Fri, 10 Apr 2015 07:49:05 GMT

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?

Re: Unique Visits

anbu1984 — Fri, 10 Apr 2015 08:20:59 GMT

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 ];

Re: Unique Visits

Fri, 10 Apr 2015 08:31:54 GMT

Hi,

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

Regards.

Re: Unique Visits

anbu1984 — Fri, 10 Apr 2015 08:42:52 GMT

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 ];