topic Re: Show Target Line on Bar Chart in QlikView

Show Target Line on Bar Chart

pkelly — Fri, 06 Sep 2013 10:42:35 GMT

Hi All...

I have a Bar Chart which shows the number of Credit Issue created each month...

Dimension is Month Year...

COUNT(DISTINCT IF(cad_HistoricalMonthNumber >=1 AND cad_HistoricalMonthNumber <= 15, %IssueKeyHeader))

What I want to do is add a line to the chart showing, for want of a better phrase, a "Target" line...

This line will be equal to 10% below the last 15 months average of issues keyed...

I cannot do this via a script as I want this value to change dynamically if someone applies a filter...

Any ides on how I can do this?

Thanks

Paul

whiteline — Fri, 06 Sep 2013 10:51:15 GMT

Hi.

You could use combo chart and add the target line as another expression with Line representation.

To make this line constant for each months use total in count().

Add:

Another way is to use reference lines on presentation tab.

pkelly — Fri, 06 Sep 2013 11:05:20 GMT

Thanks - used the count total route...