topic Re: Chart Line Style in QlikView

Chart Line Style

Wed, 10 Sep 2014 17:52:37 GMT

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

Re: Chart Line Style

maxgro — Wed, 10 Sep 2014 20:50:36 GMT

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

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

Re: Chart Line Style

Thu, 11 Sep 2014 08:32:49 GMT

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

Any work around?

Thks,

Re: Chart Line Style

maxgro — Thu, 11 Sep 2014 09:28:04 GMT

did you open the attachment?

why isn't working?

SI lines are dotted, not SI normal

Re: Chart Line Style

Thu, 11 Sep 2014 09:37:36 GMT

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

Re: Chart Line Style

Thu, 11 Sep 2014 15:46:02 GMT

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

Re: Chart Line Style

Thu, 11 Sep 2014 15:46:18 GMT

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

Re: Chart Line Style

maxgro — Thu, 11 Sep 2014 19:34:35 GMT

post a qlik doc, if possible