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: 
Mayuri1
Contributor II
Contributor II

Plotting calculated dimension

Hi,
I have a calculated column that categorizes each user into 3 categories based on their app usage time as

1.<10 min

2.10-30 mins and

3.more than 30 mins.

(the expression uses a nested IF to come up with these categories)

I am trying to create a chart that shows number of users  by each category.

What is the best way to go about it?

Only dimension readily available is the userID.

Thank you for the assistance in advance.

5 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

As for Dimension use your recently created Category field and for Expression I think Count(Distinct userID) should work.
Shubham_Deshmukh
Specialist
Specialist

what exactly you want? you want the way to do it with cal dimension?
Mayuri1
Contributor II
Contributor II
Author

    
  CALCULATED based on a if condition 
userIDavg session timecategory 
10:05:20<10 minutes 
20:35:20More than 30 
30:12:2010-20 mins 
43:05:20More than 30 
54:05:20More than 30 
65:05:20More than 30 
    
Need a graph that calculates userIDs for each of the category in column F
    
Mayuri1
Contributor II
Contributor II
Author

The categories are a result of an expression. Does that mean I need to create a calculated dimension using the same expression?

Shubham_Deshmukh
Specialist
Specialist

There are two ways to do this, calculated dimension will take time if your data volume large.
Rather you can manage it in the script like creating Case When scenario of your categories.