How to plot line chart with two different dimensions and single expression

[rajender_qlik]

Hi everyone,

I have a table below as shown.

ID#	Section	Point	RPM	m_dot	Power
1	1	1	5620	22020	1300
1	1	2	5620	30179	1915
1	1	3	5620	30795	1915
1	1	4	5620	38270	2490
1	1	5	5620	39154	2490
1	1	6	5620	46554	3000

I want to plot the above table in Line chart showing Power on X-axis and m_dot on Y-axis. When I plot the graph its taking the Power 1915 which has m_dot of 30179 & 30795 values. But its plotting single point on 1915 with power and m_dot to be average of both values as 30487. Similar case with 2490 as Power.

I simply want all Power plots and m_dot to be plotted on line chart.

Can anyone help me with this !!

Thanks !!

Rajender

[ahaahaaha]

Hi Rajender,

May be

Dimension: [Power]

Expression: Avg(m_dot)

Andrey

[rajender_qlik]

Hi Andrey,

Thanks for your reply.

Its not working in my case. Can you share me an app with the line chart.

[chaper]

See attached App as mentioned by Andrey to use Avg(m_dot)

[rajender_qlik]

Thanks for your reply Chai Peri.

The app which u shared is fine. But When you turn the line chart to straight table which is on right side it shows 1915 as average of both values of 1915. But I need both values of 1915 and 2490 to be plotted on line chart.

If I take Point as second dimension in line chart it shows the graph i wanted but it shows only dots but i need that to be in dots joining the line.

[Anonymous]

Hi

Please find attached app. Please let us know if you are looking something else

Hope it helps!!

[rajender_qlik]

Thanks for your reply Anil kumar.

App which you shared also shows only 4 points of power. but where I have 6 values under Power column.

[chaper]

Even adding point as secondary dimension How can you expect to make line chart with two dots for one of the dimension values .Am I missing something?

[rajender_qlik]

Hi Anil & Chai Peri

I have added point as second dimension but I am getting the as dots in line chart.

But i want to join all those points and show as line. ! !

[rajender_qlik]

No thats what i am confused. I cant make a line chart using those dimensions?