topic Re: Plotting calculated dimension in QlikView

Plotting calculated dimension

Mayuri1 — Thu, 28 Feb 2019 21:42:19 GMT

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.

Re: Plotting calculated dimension

MindaugasBacius — Fri, 01 Mar 2019 05:30:42 GMT

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

Re: Plotting calculated dimension

Shubham_Deshmukh — Fri, 01 Mar 2019 07:22:57 GMT

what exactly you want? you want the way to do it with cal dimension?

Re: Plotting calculated dimension

Mayuri1 — Fri, 01 Mar 2019 16:20:39 GMT


		CALCULATED based on a if condition
userID	avg session time	category
1	0:05:20	<10 minutes
2	0:35:20	More than 30
3	0:12:20	10-20 mins
4	3:05:20	More than 30
5	4:05:20	More than 30
6	5:05:20	More than 30

Need a graph that calculates userIDs for each of the category in column F

Re: Plotting calculated dimension

Mayuri1 — Fri, 01 Mar 2019 16:23:25 GMT

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

Re: Plotting calculated dimension

Shubham_Deshmukh — Mon, 04 Mar 2019 05:39:41 GMT

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.