topic Re: Trend line? in QlikView

Trend line?

Tue, 16 Jun 2015 18:47:54 GMT

Hi,

I have a requirement where i need to show the trend line of Revenue over the years.

Ex:

year, Rev

2011,0

2012,0

2013,2

2014,4

when i had this data on chart, trend line only shows for 2013 and 2014, but i want it to show from 2011 to 2014 i.ee line from 0 to 4.

Is it possible?

Thanks

Re: Trend line?

stigchel — Tue, 16 Jun 2015 18:51:12 GMT

Zero values are being suppressed, in the presentation tab of the properties uncheck the suppress values checkbox

Re: Trend line?

sunny_talwar — Tue, 16 Jun 2015 18:53:30 GMT

Is this the requirement?

If yes then just uncheck -> Suppress Zero-Values on the presentation tab

Re: Trend line?

Tue, 16 Jun 2015 19:13:15 GMT

Thanks,

But for the data its not letting me do that.

PFA

Re: Trend line?

sunny_talwar — Tue, 16 Jun 2015 19:15:18 GMT

But for the data its not letting me do that.

What data are you referring to? Nothing is attached?

Best,

Sunny

Re: Trend line?

Tue, 16 Jun 2015 19:16:31 GMT

Sorry PFA

Re: Trend line?

sunny_talwar — Tue, 16 Jun 2015 19:22:19 GMT

Used a CrossTable load to first fix the data in a structure which can be used easily:

Table:

load * inline [

ID, Jan,Feb,Mar,Apr,May,Jun,Jul

1,0,0,0,0,300,400,0

2,0,500,600,700,0,800,0

3,0,0,0,0,0,800,900];

Table1:

CrossTable(Month, Data, 1)

LOAD *

Resident Table;

DROP Table Table;

And then replicated the chart we had initially:

Re: Trend line?

Wed, 17 Jun 2015 18:10:59 GMT

HI,

Any idea how to have $ sign on Y axis?

I changed the format to money in number tab, but still its the same.

Thanks

Re: Trend line?

sunny_talwar — Wed, 17 Jun 2015 18:43:19 GMT

Does this work?

Added it on the Numbers tab:

HTH

Best,

Sunny

Re: Trend line?

Wed, 17 Jun 2015 19:02:47 GMT

Thanks,

But can we have $ sign next to all values on Y axis?

Re: Trend line?

sunny_talwar — Wed, 17 Jun 2015 19:48:00 GMT

Was just playing around with the settings and checking out other threads on the community, I came across this: Re: In bar chart $ symbol can't be prefixed to the numbers in y-axis? and according to this if we add Static step we can see the number format from Number's tab flow in into the chart's axis. Tried it and seems to be working pretty well:

Not sure if its a bug, but seems to work.

HTH

Best,

Sunny