Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Quartiles

I'm trying to run an analysis that has Customers and Sales Amount and break the Sales into quartiles. I would like to create a box plot to show what the quartiles are across ALL customers. However, if I use the box-plot wizard then I am forced to have a Dimension and Aggregator so then it breaks down the data by Customer.

How can I create a chart to show what the quartile ranges are for Sales Amount, across ALL customers? If box-plot isn't the best method for this, then I'm fine with other charts too.

1 Reply
Clever_Anjos
Employee
Employee

Easy fast trick

LOAD * INLINE [

    F1

    dummy

];

And then use F1 as dimension