Legend and Filter

pacoli2013 — Fri, 17 Mar 2017 11:58:21 GMT

Hello,

I have a Barchart with 6 expressions and showing the legend. I have a listbox 'Company' with two companies (ECO & ESB).

The expressions are :

2* Sum(Budget): total and product

2* Sum(Sales) for Company 1, divided in products and Batch

2* Sum(Sales) for Company 2, divided in products and Batch

The four sum(sales) are stackt barcharts, the sum(Budgets) are two lines.

The legend shows always the 6 expressions.

But when I select Company 1, I want to see the expressions belonging to Company 1: the two Budgets and the two Sales.

When I select Company 2, I want to see the expressions belonging to Company 2: the two Budgets and the two Sales

When I select both companies or with no selection I want to see all six.

In the script I created two variables:

SET vLegendCompany1='=GetPossibleCount(Company)=1';

SET vLegendCompany2='=GetPossibleCount(Company)=1';

In the Expression tab I activate conditional with vLegendCompany1 for expressions Company 1, and vLegendCompany2 for expressions Company 2.

I have added four Screen shots with the four possible selections and results and a qvw as testdocument

The only result I got, is that when I select both companies or no companies all four Sales expressions disappear (see: both companies selected.jpg)

I tried a wildmatch, didn't work. Tried an IF-Statement, didn't work. So I'm at the end of my possibilities and hope that there is someone who has an other solution which works in the Chart

Thanks in regard

Court

Re: Legend and Filter

sunny_talwar — Fri, 17 Mar 2017 13:28:07 GMT

Check the attached.... there are other ways to do this... but this seemed like an easy way because you only had 2 companies.... could there be more companies? I can give you other options or you can look here

Customizable Straight Table

topic Re: Legend and Filter in QlikView

Legend and Filter

Re: Legend and Filter