Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Count active users during a selected timeframe

I am creating an app over Salesforce and one of the requirements is to show how many users were active at a point in time. I have the following fields..

IsActive - True/False

FunctionStartDate

FunctionEndDate

The aim is to show how many users had the IsActive flag set to True during the period of time selected.

In addition, if a user was active for a partial month (3.5 for example) can that be calculated..

Cheers

2 Replies

Re: Count active users during a selected timeframe

Have a look at the IntervalMatch() function.

Here is a great blog by Henric all about it IntervalMatch

Not applicable

Re: Count active users during a selected timeframe

Hi Bill

Many thanks for the reply. I'll give it a read..

Cheers

Tony

Community Browser