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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

trying to create a line chart with 2 expressions and I want a line to be drawn

Hi, I am trying to create a line chart with one dimension as Year. I have got 2 expressions 1 for YTD current year and 1 for YTD last year. They are completely different expressions. When I do the line chart they appear as 2 dots and the line is not drawn between them. And obviously as these are 2 different expressions. Is there any workaround to draw the line. I want to show the movement from 2012 to 2013. Any chart will do if it can accomodate my requirement.

Thanks,

Ram

3 Replies
MayilVahanan

Hi

You can use bar chart or pivot/Straight table.

hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Replace your two expressions with one expression: if(Year=2012, ...2012-expression-here..., ...2013-expression-here...).


talk is cheap, supply exceeds demand
Not applicable
Author

=if([Field1]='$(lvYear)',(Sum( {1<[Field1]={'$(lvYear)'}>} [Retail Net]))/1000000, (Sum( {1<[Field1]={'$(lvPrevYear)'}>} [Retail Net]))/1000000)

I tried, but this doesn't work.