topic Re: Set Expression in QlikView

Set Expression

hkg_qlik — Wed, 13 Jun 2012 13:35:10 GMT

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,

CELAMBARASAN — Wed, 13 Jun 2012 13:42:51 GMT

Hi,

Check with this

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

Celambarasan

MayilVahanan — Wed, 13 Jun 2012 13:47:36 GMT

Hi,

Try this,

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

Hope it helps

hkg_qlik — Wed, 13 Jun 2012 14:46:20 GMT

Its giving me incorrect COUNT of personID.

chematos — Wed, 13 Jun 2012 14:56:45 GMT

Try this:

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

Make sure both dates are with the same type