Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aviadbein
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:

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

0 Replies