Discussion board where members can get started with QlikView.
Could anyone please provide me with the solution how to make year of 2011 to become dashed?
There is only one expression. How to write a correct Line Style Definition? Or any other ideas are welcome.
Thank you for your effort!
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
Attaching a sample:
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?
TOTAL is just putting the Max(Year) value across all the rows (even where Year = 2014)