Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

Hi everyone,

I have a table below as shown.

   

ID#SectionPointRPMm_dotPower
1115620220201300
1125620301791915
1135620307951915
1145620382702490
1155620391542490
1165620465543000

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

11 Replies
Highlighted
Master
Master

Hi Rajender,


May be

Dimension: [Power]

Expression: Avg(m_dot)


Andrey

Highlighted
Creator
Creator

Hi Andrey,

Thanks for your reply.

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

Highlighted
Creator III
Creator III

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

Highlighted
Creator
Creator

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.

Capture.PNG

Highlighted
Specialist II
Specialist II

Hi

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

Hope it helps!!

Highlighted
Creator
Creator

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.

Highlighted
Creator III
Creator III

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?

Capture.PNG

Highlighted
Creator
Creator

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. ! !

Highlighted
Creator
Creator

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