Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

spividori
Valued Contributor

line chart

Hi.

I have a line chart with 2 dimensions, Month and Color. In addition to the monthly sum of each color, you would need to show, if possible in some way, an additional line that shows the general monthly average.

Regards.

1 Solution

Accepted Solutions

Re: line chart

Check the attached

6 Replies

Re: line chart

May be using Reference line

Capture.PNG

spividori
Valued Contributor

Re: line chart

Sorry, I expressed myself badly, the line should show the average of each month. My english is poor!.

Regards.

Re: line chart

Oh it seems that you need a line that changes month over month... vs. a straight line which is an overall average. Is that correct? You might need to use 1 dimension with multiple expressions to get that...

Re: line chart

No you were clear, it was my bad that I mis-understood this...

Re: line chart

Check the attached

spividori
Valued Contributor

Re: line chart

Great idea!.

I have to put my brain to work a little bit more!

It is useful to me!.

Thank you.

Regards.

Community Browser