topic Re: Need help in expression in QlikView

Need help in expression

Thu, 14 Nov 2013 07:02:04 GMT

Hi All

i Have two fields User Id & Last Signed Date ,I need the count of User Id's who have signed in within last 60 days.need to write an expression for this

User Id            Last Signed Date
1                         11/11/13
2                         12/10/13
3                          04/10/13
4                          05/04/13
5                          06/02/13

The date format is (DD/MM/YYYY)

Thanks in advance

Re: Need help in expression

kaushiknsolanki — Thu, 14 Nov 2013 07:07:07 GMT

Hi,

Try this.

Count({<LastSignedDate = {">=$(=Date(Today()-60,'DD/MM/YYYY'))"}>}User_ID)

Regards,

Kaushik Solanki

Re: Need help in expression

jagan — Thu, 14 Nov 2013 07:17:04 GMT

Hi Senthil,

Try this expression

=Count({<[Last Signed Date]= {">=$(=Date(Today()-60,'DD/MM/YYYY'))<=$(=Date(Today(), 'DD/MM/YYYY'))"}>}

[User Id])

If you want unique Users count then use this expression

=Count({<[Last Signed Date]= {">=$(=Date(Today()-60,'DD/MM/YYYY'))<=$(=Date(Today(), 'DD/MM/YYYY'))"}>}

DISTINCT [User Id])

Hope this helps you.

Regards,

Jagan.

Re: Need help in expression

mdmukramali — Thu, 14 Nov 2013 07:18:26 GMT

Dear,

Kindly find the attachment.

Thanks,

Mukram.

Re: Need help in expression

Thu, 14 Nov 2013 07:34:00 GMT

Thanks ...

It worked..