Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

dispersion chart with avg and max

Hi all

I need help to draw a graphic!

example: any idea?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

dispersion chart with avg and max

Well, the average is easy, at least if all you want is a linear trendline. Just select a linear trendline for the expression. The max is more complicated. You only have one data point, so you technically can't make a line, but I'm guessing you want the line to go through (0,0). That makes the formula for your line just max(total "Margin %") * Sales. However, your linear trend line for the average doesn't necessarily go through (0,0). If you want it to be consistent with your max line, you might want to use Sales * sum(total Margin)/sum(total Sales).

What I don't know how to do is to set the bubble size to the Margin %. However, this is already roughly indicated by the position of the bubble. If it's above the average line, it's higher than average. If it's below the average line, it's lower than average. It doesn't seem like you'd need a second indicator of good margins.

If you really, really do, you could probably overlay a line chart on a scatter chart. A simple scatter chart allows for the linear trend line, but I don't think allows you to put in additional lines except for vertical or horizontal reference lines.

View solution in original post

2 Replies
Highlighted
MVP
MVP

dispersion chart with avg and max

Well, the average is easy, at least if all you want is a linear trendline. Just select a linear trendline for the expression. The max is more complicated. You only have one data point, so you technically can't make a line, but I'm guessing you want the line to go through (0,0). That makes the formula for your line just max(total "Margin %") * Sales. However, your linear trend line for the average doesn't necessarily go through (0,0). If you want it to be consistent with your max line, you might want to use Sales * sum(total Margin)/sum(total Sales).

What I don't know how to do is to set the bubble size to the Margin %. However, this is already roughly indicated by the position of the bubble. If it's above the average line, it's higher than average. If it's below the average line, it's lower than average. It doesn't seem like you'd need a second indicator of good margins.

If you really, really do, you could probably overlay a line chart on a scatter chart. A simple scatter chart allows for the linear trend line, but I don't think allows you to put in additional lines except for vertical or horizontal reference lines.

View solution in original post

Highlighted
Partner
Partner

dispersion chart with avg and max

Thanks

Grazie

Andrea