topic Boxplots for non aggregated measures in App Development

Boxplots for non aggregated measures

TinaHensel — Fri, 16 Apr 2021 11:02:11 GMT

Hello,

I have some issues on using Boxplots in Qlik Sense.

Lets say I have the following data:

date | seconds

16.04.2021 | 1

16.04.2021 | 4

16.04.2021 | 8

16.04.2021 | 3

15.04.2021 | 1

15.04.2021 | 2

15.04.2021 | 1

...

Now i want to create a Boxplot with the dimension date and seconds as measure. I have no ideas how to setup the values for "dimenson -> box" and "dimenson -> x axis".

Any ideas on how to do this?

Thank you very much!

Re: Boxplots for non aggregated measures

rubenmarin — Sat, 17 Apr 2021 08:23:14 GMT

Hi, you can add an identifier for each row, like a new field with just "RowNo() as row".

The set this row fied as box, date as x-axis and seconds as y-axis

LOAD *, RowNo() as row Inline [ date | seconds 16.04.2021 | 1 16.04.2021 | 4 16.04.2021 | 8 16.04.2021 | 3 15.04.2021 | 1 15.04.2021 | 2 15.04.2021 | 1 ](delimiter is '|')

Re: Boxplots for non aggregated measures

TinaHensel — Mon, 19 Apr 2021 08:31:24 GMT

Working, thank you!