topic Re: Dimensions on datapoints in QlikView

Dimensions on datapoints

mcornips — Sun, 26 Jan 2014 17:27:30 GMT

I have several types of country scores. In a chart I am using one score-type as an expression and the other score-types as dimensions. This enables me to investigate correlations between the scores.

I am using a line chart in which all the data points are displayed as symbols. I can simply add the values of the score type which I use as an expression to the data points/symbols. But how can I add the country names (dimension values) to the data points/symbols?

Maurice

Re: Dimensions on datapoints

MK_QSL — Sun, 26 Jan 2014 17:38:40 GMT

Is it what you are looking for?

if not, kindly load your apps.

Re: Dimensions on datapoints

Sun, 26 Jan 2014 17:40:48 GMT

Hi,

You can make a calculated dimension by concatenating country names and first scores:

= CountryName & ' - ' & FirstScore

then sort this dimension by Maxstring(FirstScore&CountryName) ascending for example.

Hope this helps

Re: Dimensions on datapoints

maxgro — Sun, 26 Jan 2014 20:50:59 GMT

you can change your score expression to have a text and a num value

dual(Country & chr(10) & num(Sum(Score), ',#,##0'), Sum(Score))

flag "Value on Data Points" in "Expression" tab

set "Expression Default" as "Number Format Settings" in Number tab

Re: Dimensions on datapoints

mcornips — Sun, 26 Jan 2014 22:43:15 GMT

All answers are helpful. You are showing the dimension 'country' on the X-axis. My X-axis shows another score type as a dimension with a value range. The country dots display the country's score on the Y-axis and on the X-axis.

I just needed to add the field 'country' as an expression and then activate the 'Values on Data Points' and hide the lines or symbols for this expression.

The problem I have now is that countries with the same dimension scores are not displayed. Probably because he totalizes the scores for each dimension (which is another score).

Re: Dimensions on datapoints

mcornips — Sun, 26 Jan 2014 23:05:35 GMT

In the attached QVW the score_B values 7 and 9 do not show a country since more countries do have these values 7 and 9 on Score_B.

Re: Re: Dimensions on datapoints

maxgro — Mon, 27 Jan 2014 14:07:18 GMT

Now that I see your chart I think is better to use a scatter chart for showing scores relations (see here Qlik Demos: See QlikView in Action | Demo.Qlik.Com for when to use which chart)

See attachment, second tab

Re: Dimensions on datapoints

mcornips — Wed, 29 Jan 2014 08:55:32 GMT

Thanks a lot Massimo, That is was the chart I was looking for.

Maurice

Re: Re: Dimensions on datapoints

mcornips — Thu, 30 Jan 2014 13:53:15 GMT

Hi Massimo,

Could you please resend me the QVW you send me with this solution?

Thanks,

Maurice

Re: Dimensions on datapoints

maxgro — Thu, 30 Jan 2014 14:04:12 GMT

you can download it (attachment) 2 post above, Jan 27, 2014 3:07 PM