topic Re: Chart Line Style in QlikView

Chart Line Style

Thu, 11 Sep 2014 17:20:19 GMT

Hi,

I created a line chart with:

Dimensions:
- Month
- Metric_Type & ' - ' & Product
Expression:
- =Sum({<Year=, Month=, Year_Month={">=$(=Max(Year_Month)-99) <=$(=Max(Year_Month))"}>}Values)
- I use this expression so the chart can show the last 12 months (select Year and Month included)

I want to format the "Line Style" of the Expression for the different Metric_Type (SO or SI) using:

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

But it doesn't work!!!

But If I use an Expression without Set Analysis like:

=Sum(Values)

It Works!

Any Suggestions??

Thanks in advance,

Francisco

Re: Chart Line Style

phaneendra_kunc — Thu, 11 Sep 2014 18:49:25 GMT

it will be nice if you share a sample QVW. i dont see a problem in your expressions.

Re: Chart Line Style

Anonymous — Thu, 11 Sep 2014 19:22:08 GMT

Make sure to write your if statement in the line Style location. I added a picture to show where your expression should be written. Please note that This type of attribute expression only has effect on line, combo and radar charts. but it doesn't work with other type of charts.

Thanks and regards,

Walid

Re: Chart Line Style

gmoraleswit — Thu, 11 Sep 2014 19:53:50 GMT

Hi Francisco,

Maybe the problem is that in your expression

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

Metric_Type is not a single value but a set of values, a condition cannot be evaluated comparing a set of values, I suggest to use an aggregation function only(), maxstring(), just be very careful as you are comparing string values.

Here more info: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/16/use-the-aggregation-functions

Re: Chart Line Style

IAMDV — Thu, 11 Sep 2014 20:38:21 GMT

Hi Francisco,

Does the Metric_Type field return only value? Also, it will be easy if you can post the sample QVW.

Cheers,

www.QlikShare.com

Re: Chart Line Style

Fri, 12 Sep 2014 11:08:57 GMT

How can I share the Qvw?

I only see the options Insert Image, video and Link!

Thks,

Francisco

Re: Chart Line Style

phaneendra_kunc — Fri, 12 Sep 2014 13:43:26 GMT

Whe you hit Reply on top right corner of that editor you will see Advanced Editor. Click on that and that will give you an option to upload QVW.

Re: Chart Line Style

Fri, 12 Sep 2014 13:55:18 GMT

Hello everyone,

The sample qvw is attached.

Thanks,

FLC

Re: Chart Line Style

phaneendra_kunc — Fri, 12 Sep 2014 15:25:01 GMT

Use this.

=if(Only({<Month=,Year=>}Metric_Type)='SI','<S3>')

you have to ignore the fields that your are ignoring in your main expressions.

Also one suggestion...

in your qvw you are refering to mid(product,1,2) in which "product" is a dimension column label. which you can not refer like this as you can do it for expressions.

Re: Chart Line Style

Fri, 12 Sep 2014 15:28:57 GMT

Perfect!

Yes I know about mid(product,1,2), tha was about another issue, but I understand your point...

Thank you.

Re: Chart Line Style

Anonymous — Fri, 12 Sep 2014 16:54:38 GMT

Hi Francesco,

How did you make Month and Year fixed and cannot be cleared from current selections. I thought this is a trigger but I didn't find any actions in your application. Can you explain this please.

Thanks and regards

Re: Chart Line Style

Mon, 15 Sep 2014 09:43:43 GMT

Hi,

In the properties of the objects, "General" tab, check "Always one selected value".

Regards,

Francisco

Re: Chart Line Style

Mon, 15 Sep 2014 09:44:37 GMT

Hi,

In the properties of the objects, "General" tab, check "Always one selected value".

Regards,

Francisco