Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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