Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimensions in scatter chart + Dimension font size and bold attributes

Hi Forum! 🙂

Background info:
Table 1:
For scatter chart position and x and y expressions
Name, y-pos, x-pos
Alfa, 10, 5
Beta, 5, 15
Gamma, 15, 12

Table 2: Data transactions
Name, value
Alfa, 1
Alfa, 2
Alfa, 6
Beta, 1
Beta, 1
Gamma, 1

The Z expression is sum(values) - and all this in a scatter chart.

Questions:
1. In the dimension I would like the name AND value to show in the scatter chart. Is this possible?
Example: "Alfa - 9", "Beta - 2", "Gamma - 1" some like =Name & aggr(sum(value))

2. I tried just getting the sum of the values first and show in the legend; tried this =aggr(sum(value)) - why doesnt this work?

3. Under text format, how do you make the font size bigger in a scatter chart?

(I am currently in 9.0 QV)

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Tobbe,

1. The expression of calculated dimension is like this:
=aggr(Name & ' value=' & sum(value), Name)

2. You have to tell by what dimension to aggregate. It should be by Name in your case (bold above)

3. Font - use Font buttons on "Axes" tab in chart properties, not the "Font tab.


An example is attached.

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Tobbe,

1. The expression of calculated dimension is like this:
=aggr(Name & ' value=' & sum(value), Name)

2. You have to tell by what dimension to aggregate. It should be by Name in your case (bold above)

3. Font - use Font buttons on "Axes" tab in chart properties, not the "Font tab.


An example is attached.

Not applicable
Author

Thanks for a speedy reply Michael!
1 + 2 works great, but the third question - I think perhaps I didnt explain myself well enough.

In the axes tab I can only change the font size/formatting for the X and Y values(?).
But I would like to change the dimension font size to be bold and perhaps a bit bigger. Cant find how to do this under the axes tab - could you assist further?

Again - thanks! /Tobbe.

Anonymous
Not applicable
Author

Sorry, you mean the legend font?
If yes, go to the Presentation tab, and find "Settings..." button under the "Show Legend" checkbox. There is "Font" there too.
If you mean font size in pop-up - I don't know if you can change font there at all.

Not applicable
Author

Yep, thanks again Michael!