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: 
Not applicable

Chart Line Style

Hello,

I created a Line chart with:

  • Dimensions:
    • Month
    • Product & ' - ' & Metric_Type (Calculated Dimension)
  • Expression:
    • (Sum({<$(vMAT)>}Values) - the variable is to show the last 12 month

I have two Metric_Type (SO and SI). I want the the Line Style to be different for the Metric_Types, so I tried this scripts in the Line Style of the expression:

  • =if(Metric_Type='SI','<S3>')
  • =if(mid(Product & ' - ' & Metric_Type,1,2) ='SI','<S3>')

but didn't work...

Suggestions?

Thanks in advance,

Francisco

7 Replies
maxgro
MVP
MVP

I think your first expression should work (it seemms to work in the attachment)

=if(Metric_Type='SI','<S3>')

Not applicable
Author

Yes thats what I thought, but its not working...

Any work around?

Thks,

maxgro
MVP
MVP

did you open the attachment?

why isn't working?

SI lines are dotted, not SI normal

1.png

Not applicable
Author

Yes it looks like what I, did but its not working...

If I did not find the solution, I will send you the qvw...

Rgds,

FLC

Not applicable
Author

The problem is my expression as set analysis to show the last 12 months including the selected month:

=Sum({<Year=, Month=, Year_Month={">=$(=Max(Year_Month)-99) <=$(=Max(Year_Month))"}>}Values)

if I use a simple expression like:

=Sum(Values)

and select the 12 months it works fine!

Is there a solution using the first expression?

Regards,

FLC

Not applicable
Author

The problem is my expression as set analysis to show the last 12 months including the selected month:

=Sum({<Year=, Month=, Year_Month={">=$(=Max(Year_Month)-99) <=$(=Max(Year_Month))"}>}Values)

if I use a simple expression like:

=Sum(Values)

and select the 12 months it works fine!

Is there a solution using the first expression?

Regards,

FLC

maxgro
MVP
MVP

post a qlik doc, if possible