Handling Unwanted Aggregations in Line Graphs

Thu, 31 Mar 2016 18:18:52 GMT

This is a simplification of my predicament, but I am having some problems making things aggregate correctly without losing human readability. I guess the question I am asking is how I could either have better control of my aggregation or axis/legends.

Suppose I am trying to make a line graph of 4 users with this data:

User ID	Name	Sign-up Date	X-axis (first dimension)	Y Axis Expression
AMK292732A	Steve	1/2/2016	1	10
MK23554642A	John	1/1/2016	1	20
TW335454	Steve	1/3/2016	1	30
CD34542SSgfz	Pat	1/1/2016	1	40
AMK292732A	Steve	1/2/2016	2	10
MK23554642A	John	1/1/2016	2	20
TW335454	Steve	1/3/2016	2	30
CD34542SSgfz	Pat	1/1/2016	2	40

The correct graph for this, theoretically, should be 4 parallel lines, but i am having difficulty controlling the details so that it is logical for the human to know what they are looking at. This is what I have tried so far:

1. Using Name as second dimension (no good):

This will only make 3 lines, as the two people who are named Steve will be aggregated with each other

2. Using the Sign-up Date as second dimension (no good):

This isn't much better, although the two Steves have different sign up dates, this will together Pat and John because they signed up on the same day.

3. Using the User ID as second dimension (functional, least readable):
This will give us with our intended result, our legend will point to "CD34542SSgfz" as a user, which is not readable.

I could theoretically create another column that concatenates the sign up dates with the name, but that isn't that much more readable and my actual data also has very long strings as names.

Ideally, I would like the key to have repeating values ( like, the key would have has a green steve and a blue steve)

Anyone have any suggestions or point me to a solution?

Re: Handling Unwanted Aggregations in Line Graphs

swuehl — Thu, 31 Mar 2016 21:27:39 GMT

Maybe create a calculated second dimension, like

=[User ID] & ' - ' [Name]

or if you want repeating names

=Dual( [Name], FieldIndex( 'User ID', [User ID]) )

Re: Handling Unwanted Aggregations in Line Graphs

Wed, 06 Apr 2016 16:03:49 GMT

YOU ARE THE BEST

topic Re: Handling Unwanted Aggregations in Line Graphs in QlikView

Handling Unwanted Aggregations in Line Graphs

Re: Handling Unwanted Aggregations in Line Graphs

Re: Handling Unwanted Aggregations in Line Graphs