Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count/group no. of users based on their active months usage?

Hi folks,

Could someone help me out with an issue at hand. Please take a look at the picture below:

CountUser.jpg

So the columns are the userID, the no. of days the user has been actively using a particular service and a grouping field to group the users based on their usage - in active months. I would like to group this users for e.g., if there are 10 users that fall into the 1-3 months category, I would like to group them all together and place it into a chart/table to show that there are 10 users whom fall into the 1-3 months category, so on and so forth.

Hope ya'll get the picture, if you guys require further clarification please do let me know. Thanks. Cheers.

Best Regards,

R

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA file for solution.

Regards,

Jagan.

View solution in original post

9 Replies
jagan
Luminary Alumni
Luminary Alumni

HI,

Use ActiveMonth as dimension and use Count(DISTINCT UserID) as expression.  This groups the users by ActiveMonth.

Regards,

Jagan.

Not applicable
Author

Thanks Jagan, will try it out. Let you know how it goes.

Not applicable
Author

Hi Jagan Mohan - it's not working as claimed. Any other ideas?

jagan
Luminary Alumni
Luminary Alumni

Hi,

It should work as expected.  Can you attach some sample file and expected output, it helps in providing solution easier.

Regards,

Jagan.

Not applicable
Author

Hi Jagan,

I will work on one right now and post it up right away.

Thanks.

Best Regards,

R

Not applicable
Author

Hi Jagan Mohan

Please take a look at the attachment.

Thanks.

Best Regards,

R

jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA file for solution.

Regards,

Jagan.

Not applicable
Author

Hi Jagan Mohan

- Sorry man, am unable to open .qvw files as am still using the free edition. Could you please post the script up for me?

Thanks a bunch, sorry for the hassle.

jagan
Luminary Alumni
Luminary Alumni

Hi,

In Straight Table ->

Dimension - ActiveMths_Grp

Expression - =Count(DISTINCT UserID)

Regards,

Jagan.