Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
waqasshah
Creator
Creator

BoxPlot Chart Issue

Hi Guys,

I want to create a box plot chart but I am facing some difficulty. I have attached excel sheet and the proposed result set. The excel sheet has three columns

   

AverageDays ,  Year,  Month -Year

The Month- Year column will be on x axis or we can say it will come in dimensions. Average Days will be on y axis... then I need to show each month the average days... Please review the screenshots.

Thanks in advance

Kind Regards

Waqas Shah

1 Solution

Accepted Solutions
johncaqc
Specialist
Specialist

Okay, like this? I just added another expression, Sum(Referrals), then adjusted formatting of it. BTW, I turned on both Values on Data Points and Text on Axis for this new expression. Use your preference here.

Thread 297731 - AverageDays and Referrals.png

HTH,

John

View solution in original post

6 Replies
johncaqc
Specialist
Specialist

PFA one possible solution...based on your data provided. I included expressions for outliers but they are disabled.

Thread 297731.png

Regards,

John

waqasshah
Creator
Creator

Dear John,

many thanks for your reply. Silly me I did a slight mistake in uploading the datasheet. I have another column  called referrals.. The x axis will be same like month-year and the average days will be on y axis but referrals data will be in box plots. I have uploaded the latest dataset. Can you please check now ? many thanks for your help

johncaqc
Specialist
Specialist

I don't see how you can create a single box plot with both Referrals and AverageDays on the y-axis, or even why you would even try. But, just replace the AverageDays name with Referrals in each expression.

Thread 297731 - Referrals.png

Thread 297731 - Expression BPM.png

HTH,

John

waqasshah
Creator
Creator

Thanks John.. the concept is like on y axis we have average days that is fine but we need to see total number of refferals in box plot. like in my dataset the total numbers of referrals in April 2017  are 29 and in May 2017 are 94.....

So each month is a box plot  with total number of referrals... I hope you understand my point ..

Kind  regards

Waqas Shah

johncaqc
Specialist
Specialist

Okay, like this? I just added another expression, Sum(Referrals), then adjusted formatting of it. BTW, I turned on both Values on Data Points and Text on Axis for this new expression. Use your preference here.

Thread 297731 - AverageDays and Referrals.png

HTH,

John

View solution in original post

waqasshah
Creator
Creator

Thanks I will test and let you know...many thanks again..