Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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.

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

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

share the sample qvw.

View solution in original post

7 Replies
Highlighted
Specialist III
Specialist III

Capture1.PNGyou can use a scroll bar.

Highlighted
Specialist
Specialist

Hi Krishna Chaitanya,

Im looking for a chart something like:

qvss2.png

but my chart is seperated with trends like:

qv ss.png

Highlighted
Master III
Master III

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

Highlighted
Specialist III
Specialist III

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

share the sample qvw.

View solution in original post

Highlighted
Specialist
Specialist

Thanq Krishna Chaitanya,

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

Thanq verymuch.

Highlighted
Specialist
Specialist

Thanq Antonio.

Highlighted
Specialist III
Specialist III

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