topic Creating dynamic Reference Lines in a Bar Chart in QlikView

Creating dynamic Reference Lines in a Bar Chart

Thu, 03 Dec 2015 19:37:29 GMT

Hello everyone,

I am creating a Bar Chart which displays the Turnover percentage of each area of a Company.

I want do add a reference line to the chart, that change the value when the user apply a filter.

Below is the field and value that i want to add as a Reference Line:

"Farma Brasil" will be one Reference Line and "Farma Total" will be the second Reference Line.

So, whenever the user filter the year, the line value should change according to the "Turnover Total" value.

Thanks

swuehl — Thu, 03 Dec 2015 19:41:27 GMT

Create two reference lines on presentation tab.

The expression for the reference lines may look like

=Only({<Company = {'Farma Brasil'}>} [Turnover Total])

resp.

=Only({<Company = {'Farma Total'}>} [Turnover Total])

and will only return a values with a selected Year.

MK_QSL — Thu, 03 Dec 2015 19:41:41 GMT

Add two reference lines as below

Avg({<Company = {'Farma Brasil'}>}[Turnover Total])

Avg({<Company = {'Farma Total'}>}[Turnover Total])