Boxplots for non aggregated measures

[TinaHensel]

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!

[rubenmarin1 · Accepted solution]

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 '|')

[TinaHensel]

Working, thank you!