Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Conditional Display on chart with two dimensions

Hi all,

In Forecast app I've got conditional display so that the user can choose to display objects by Weighted or Unweighted data.

It goes like this:

in the script:


    AmountType, AmountTypeDes

    1, Weighted

    2, Unweighted


so the user can choose display by Filter Pane:


and in objects expression:

if(if(SubStringCount(Concat(AmountType,'|'), '1') =1,1,2)=1,sum(WeightedAmount),sum(UnweightedAmount))

NOW, this condition works just fine in most objects, BUT it's not working in Bar Chart with two dimensions.

For example, there is a "Region Amount by Year" Stacked Bar Chart with two dimensions: Year and Region, and the expression above.

but, it's only display sum(UnweightedAmount) values while it's not responding to display choice that made by the Filter Pane (Weighted/Unweighted).

Why so?

Thanks in advance,


0 Replies