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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Multiple expressions in Line Chart should appear as a single line

Hi,

I need to build a line chart with Year dimension and around 10 expressions built on set analysis that has value for a year for instance fist expression has value for 2007 , 2nd has value for 2008.... 10th has value for 2016.

So now i see all the expressions being represented as single dot on each year.

Is there any way i get to plot a line between these points to show a flow

4 Replies
MK_QSL
MVP
MVP

It would be better, if you provide few lines of sample data and then explain.

sunny_talwar

If you have year as dimension, why do you need 10 different expressions? From your description, it might seem you are doing something like this

Dimension

Year

Expression

Sum({<Year = {2007}>}Measure)

Sum({<Year = {2008}>}Measure)

Sum({<Year = {2009}>}Measure)

Sum({<Year = {2010}>}Measure)

... and so on

May be all you need is to use one expression like this

Sum(Measure)

and if you always want to see all years, you can do this

Sum({<Year>}Measure)


or this for latest 10 years

Sum({<Year = {"$(='>=' & (Year(Today()) - 9) & '<=' & Year(Today()))"}>}Measure)


anushree1
Specialist II
Specialist II
Author

Hi All,

Thanks for the replies I solved the problem using combination of pick and match.

@ Sunny: Thanks for trying to help me. But the measure is not the way you assumed it . I am supposed to create each on of them maybe my description is not detailed. Thanks anyways

sunny_talwar

Glad that it got resolved... please close the thread by marking correct and helpful responses.

Best,

Sunny