topic Re: linechart trend in QlikView

linechart trend

markgraham123 — Wed, 05 Aug 2015 15:37:45 GMT

Hi all,

In a line chart,

I'm using Month and Year as dimensions and COunt(Distinct()) function in expression.

I'm was trying to get the trend for 2014 and 2015 one above the other. But, my years were seperated and eventually consuming more space on the front end.

Can someone look into this.

Please find the screenshot for current trend.

Re: linechart trend

Qrishna — Wed, 05 Aug 2015 15:42:12 GMT

you can use a scroll bar.

Re: linechart trend

markgraham123 — Wed, 05 Aug 2015 15:45:20 GMT

Hi Krishna Chaitanya,

Im looking for a chart something like:

but my chart is seperated with trends like:

Re: linechart trend

antoniotiman — Wed, 05 Aug 2015 15:45:50 GMT

Use 2 Dimensions (Month and Year) and 1 Expression : Count()

Re: linechart trend

Qrishna — Wed, 05 Aug 2015 15:47:25 GMT

the month-year values are different hence the lines are not merging..

share the sample qvw.

Re: linechart trend

markgraham123 — Wed, 05 Aug 2015 16:03:47 GMT

Thanq Krishna Chaitanya,

I will load them with same month name seperated by year.

Thanq verymuch.

Re: linechart trend

markgraham123 — Wed, 05 Aug 2015 16:03:59 GMT

Thanq Antonio.

Re: linechart trend

Qrishna — Wed, 05 Aug 2015 16:09:17 GMT

You Welcome.

You can try something like this:

Put these in your chat

Dimension : Month or Year

Expressions : Sum({<year={$(=max(year))}>}field) //for current year

Sum({<year={$(=max(year)-1)}>}field) //for previous year

output: