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:
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