Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

linechart trend

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.

Tags (1)
1 Solution

Accepted Solutions
krishna_2644
Valued Contributor III

Re: linechart trend

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

share the sample qvw.

7 Replies
krishna_2644
Valued Contributor III

Re: linechart trend

Capture1.PNGyou can use a scroll bar.

markgraham123
Contributor II

Re: linechart trend

Hi Krishna Chaitanya,

Im looking for a chart something like:

qvss2.png

but my chart is seperated with trends like:

qv ss.png

antoniotiman
Honored Contributor III

Re: linechart trend

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

krishna_2644
Valued Contributor III

Re: linechart trend

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

share the sample qvw.

markgraham123
Contributor II

Re: linechart trend

Thanq Krishna Chaitanya,

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

Thanq verymuch.

markgraham123
Contributor II

Re: linechart trend

Thanq Antonio.

krishna_2644
Valued Contributor III

Re: linechart trend

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: Capture1.PNG

Community Browser