Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Year over Year chart. Different line styles

Hello,

Could anyone please provide me with the solution how to make year of 2011 to become dashed?

Screenshot_1.png

There is only one expression. How to write a correct Line Style Definition? Or any other ideas are welcome.

Thank you for your effort!

1 Solution

Accepted Solutions
sunny_talwar

May be like this in Line Style Expression

If(Year = Max(TOTAL Year) - 1, <S2>) or

If(Year = 2011,  <S2>)


If(Year = Max(TOTAL Year) - 1, '<S2>') or

If(Year = 2011,  '<S2>')

View solution in original post

4 Replies
sunny_talwar

May be like this in Line Style Expression

If(Year = Max(TOTAL Year) - 1, <S2>) or

If(Year = 2011,  <S2>)


If(Year = Max(TOTAL Year) - 1, '<S2>') or

If(Year = 2011,  '<S2>')

sunny_talwar

Attaching a sample:

Capture.PNG

MindaugasBacius
Partner - Specialist III
Partner - Specialist III
Author

I see from your sample that everything works.

But to understand it clear I would like to know what does TOTAL Year mean in the statement?

sunny_talwar

TOTAL is just putting the Max(Year) value across all the rows (even where Year = 2014)

Capture.PNG