I'm trying to create a box plot with two bars, one for the default state and one for an alternate state by they keep stacking ontop of eachother. This works perfect when doing an ordinary bar chart. Doesn't box plot work with alternate state?
I tried also with just a calculated dimension Valuelist('Group1','Group2') but it didn't work either. I spoke to Qliktech and they said that alternate state and grouped mode for box plot isn't supported. It would be excellent if you know a way around it.
The top expression I need is fractile(Amount, 0.9), Bottom: Fractile(Amount, 0.1) and middle: Median(Amount)
If you use valuelist then you won't be able to reference those values in the subsequent expressions, whereas if it's a dimension,then you can. Also, if you are using text, the pick() expression won't be as simple.
Say you are using 'Group 1' and 'Group 2' as the values we can use if statements in the top, bottom and middle amounts: