Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Valued Contributor 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!

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Year over Year chart. Different line styles

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
Highlighted

Re: Year over Year chart. Different line styles

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

Highlighted

Re: Year over Year chart. Different line styles

Attaching a sample:

Capture.PNG

Highlighted
Valued Contributor III

Re: Year over Year chart. Different line styles

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?

Highlighted

Re: Year over Year chart. Different line styles

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

Capture.PNG