Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

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

Hi,

PFA file for solution.

Regards,

Jagan.

9 Replies
MVP
MVP

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

HI,

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

Regards,

Jagan.

Not applicable

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

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

Not applicable

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

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

MVP
MVP

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

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

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

Hi Jagan,

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

Thanks.

Best Regards,

R

Not applicable

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

Hi Jagan Mohan

Please take a look at the attachment.

Thanks.

Best Regards,

R

MVP
MVP

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

Hi,

PFA file for solution.

Regards,

Jagan.

Not applicable

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

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.

MVP
MVP

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

Hi,

In Straight Table ->

Dimension - ActiveMths_Grp

Expression - =Count(DISTINCT UserID)

Regards,

Jagan.

Community Browser