topic Re: Multiple expressions in Line Chart should appear as a single line in QlikView

Multiple expressions in Line Chart should appear as a single line

anushree1 — Mon, 12 Jun 2017 10:27:15 GMT

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

Re: Multiple expressions in Line Chart should appear as a single line

MK_QSL — Mon, 12 Jun 2017 10:39:30 GMT

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

Re: Multiple expressions in Line Chart should appear as a single line

sunny_talwar — Mon, 12 Jun 2017 11:07:18 GMT

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)

Re: Multiple expressions in Line Chart should appear as a single line

anushree1 — Mon, 12 Jun 2017 11:45:57 GMT

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

Re: Multiple expressions in Line Chart should appear as a single line

sunny_talwar — Mon, 12 Jun 2017 11:58:55 GMT

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

Best,

Sunny