Set Expression

[hkg_qlik]

Hi,

I want to count distinct no. of PersonID if Created Date = Last Login Date. Can anyone help me with the syntax here.

Also I have created a Calendar based on the created date so that the count should change according to the month selected from the calendar.

Thanks,

H

[CELAMBARASAN]

Hi,

     Check with this

     =Sum(Aggr(if(Created Date = Last Login Date, 1, 0), Person))

Celambarasan

[MayilVahanan]

Hi,

     Try this,

          =Sum(Aggr(if([Created Date]  = [Last Login Date], 1, 0), PersonID))

     Hope it helps

[hkg_qlik]

Its giving me  incorrect COUNT of personID.

H

[chematos]

Try this:

count({<[Created Date]  = {"=[Last Login Date]"}>}PersonID)

Make sure both dates are with the same type