topic Re: Creating Reference Line for Each Expression in a Bar Chart in QlikView

Creating Reference Line for Each Expression in a Bar Chart

gouthamkk — Tue, 21 Mar 2017 11:56:54 GMT

Hi,

I have 2 expressions in a Bar Chart and these 2 expressions are Grouped. I trying to create a Reference line for each expression.

When a user selects first expression the reference line should display and when a user selects second expression the chart has to display second reference line.

Please Advise

Re: Creating Reference Line for Each Expression in a Bar Chart

rahulpawarb — Wed, 22 Mar 2017 05:39:38 GMT

Hello Goutham,

Trust that you are doing well!

I have created a sample application showing bar chart with Month as dimension & two expressions - Tax Amount & Freight. Also added two different reference lines for each expression.

To show these reference lines conditionally I have created two variables vTaxAmt & vFreight and set them using document triggers (refer below steps):

1. Go to the document properties Alt + Ctrl + D

2. Go to the Triggers tab and select field PickMetric from Field event trigger

3. Added Set variable action for both the variables as below:

vFreight
=If(GetFieldSelections(PickMetric)='Freight Amount', 1, 0)
vTaxAmt
=If(GetFieldSelections(PickMetric)='Tax Amount', 1, 0)

4. Go to the chart properties & edit reference lines in Presentation tab

5. For Tax Amount & Freight reference line set the conditional variables vTaxAmt & vFreight respectively.

Refer the sample application attached herewith.

P.S.: I have used data island to hold expression names.

Regards!

Rahul

Re: Creating Reference Line for Each Expression in a Bar Chart

gouthamkk — Wed, 22 Mar 2017 11:56:09 GMT

Hi Rahul,

Thanks for Work around. I am trying to see if there is a way by using Group expressions(using Cyclic objects) and achieve it, Instead of a drop down list box in data model.

Re: Creating Reference Line for Each Expression in a Bar Chart

rahulpawarb — Thu, 23 Mar 2017 04:51:34 GMT

Hello Goutham,

Please find the updated application attached herewith.

Let me know if you have any queries.

References:

Identifying which cyclic group value is being v... | Qlik Community

Read John Witherspoon's comment.

Regards!

Rahul