Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

LOAD * INLINE [

    AmountType, AmountTypeDes

    1, Weighted

    2, Unweighted

];

so the user can choose display by Filter Pane:

filterpane.png

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,

Aviad

Tags (1)
Community Browser