Question about Box Plots

[cbarthuly]

Hello,

I'm trying to figure out how to create a Box Plot that shows the right data.  I have data that in imported through SQL and each column is its own field (unique_root, 0-10% BL/day, 11-20% BL/day, etc.).  I want to show a box plot of all the different BL % like the screenshot from the excel attached.  Is there a way I need to group the % fields in the data load editor to do this?  Currnetly I can only see one field when I would like to see all of them.

Thanks,

Cody

[cbarthuly]

Just hoping someone could point me in the right direction.

[cbarthuly]

Bumping this again as I'm still stuck with this issue.  Any help would be appreciated.

[Øystein_Kolsrud · Accepted solution]

If I understand you correctly, then you want to turn the column labels into a dimension you can use in the boxplot. If that is the case then you are probably looking for the "Crosstable" functionality:

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...

It took me some time to wrap my head around how that function works, but there are some examples available if you search for them. This page is a good starting point:

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cro...

[cbarthuly]

@Øystein_Kolsrud  thank you for pointing me in the right direction.  For anyone looking into this, I had to create another table using the crosstable function like this:

And then set up the Box plot as such: