Discussion board where members can get started with Qlik Sense.
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 [
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).
Thanks in advance,