Separate boxplots on same calculated dimension

Fri, 11 Dec 2015 20:36:31 GMT

Hi,

I'm attempting to create multiple boxplots in a single chart with a non-existing dimension (=1), as a dimension is not relevant for my analysis (it should simply show max/min/quartiles of all data).

Imagine data as follows (sorry, I can't seem to get the table function to work).

OrderID | DaysToShipment | DaysToInvoice | DaysToPayment

1001 | 10 | 20 | 30

1002 | 11 | 21 | 31

1003 | 14 | 10 | 20

My goal is to create a boxplot-chart which contains three separate boxplots (stacked on top of one another, perhaps with labels in between), one for DaysToShipment, one for DaysToInvoice and one for DaysToPayment. However my dimension is the same (none, thus a calculated dimension as =1), which is confusing me a lot.

Can I maybe handle this by creating a custom dimension with a few values (e.g. 1, 2 and 3), and attaching an expression which is to be limited to a dimension-value? Or is this not possible with a calculated dimension?

topic Separate boxplots on same calculated dimension in QlikView

Separate boxplots on same calculated dimension