Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Creating a Candle light Chart or Box Plot Chart with custom Pop up of Plot values

cancel
Showing results for 
Search instead for 
Did you mean: 
avinashelite

Creating a Candle light Chart or Box Plot Chart with custom Pop up of Plot values

Attachments

Hi Friends,

This Document contains two part:

Part 1: Creating of BOX Plot Chart.

In one of my project , I got a request  to create Box Plot chart along with custom Pop up of the Plot values.

Qlikview provides the default options to create Box Plot chart without any pop up values option, to create a Box plot chart follow the below steps:

1.Right Click on sheet>New Sheet Object>select>Chart> Como Chart

2.In Expression, Initially Box Plot will be disabled. UN Check the bar option and select Box Plot.

3.In Expression, Box plot will appear > Click on the + mark in  Expression and  below 5 sub expression will appear.

'Box Plot Middle'

'Box Plot Bottom '

'Box Plot Top'

'Box Plot Lower Whisker'

'Box Plot Upper Whisker '

enter the fractile calculation here(refer this URL Box-and-Whisker Plots: Quartiles, Boxes, and Whiskers). This will create your Box Plot chart but this will not provide us the pop up of values. After lot of R&D I got the below solution .

Part 2:Custom POP UP  for plot values.

To achieve this we need to add one more expression and the order of the expression is important, 1st expression should be the POP Up expression followed by the Lower Outlier , Upper Outlier and Box Plot Expressions.

* POP Expression should be in Bar format and we need to make use of Dual function to build this expression.

*In Expression write the below code.

=Dual(

Fractile(Aggr(Amount,Date,Amount), 0.5)&Chr(13)

&'Box Plot Bottom = '&Fractile(Aggr(Amount,Date,Amount), 0.25)&Chr(13)

&'Box Plot Top = '&Fractile(Aggr(Amount,Date,Amount), 0.75)&Chr(13)

&'Box Plot Lower Whisker = '&Fractile(Aggr(Amount,Date,Amount), 0.05)&Chr(13)

&'Box Plot Upper Whisker = '&Fractile(Aggr(Amount,Date,Amount), 0.95)&Chr(13)

,Fractile(Aggr(Amount,Date,Amount), 0.75)-Fractile(Aggr(Amount,Date,Amount), 0.25))

*First part of the Dual function calculates the plot values and second calculates the length of the Bar where pop need to appear.

*To make the chart use friendly set the Bar offset to Box Plot Bottom, this will hide the POP UP bar behind the box plot.

Please find the attachment for the example solution.

This is my first Qlikview Document, if I had made any mistakes please feel free to correct me.

Regards,

Avinash R

Comments
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Well done, Avinashelite

Thanks for sharing

Joaquín

avinashelite

Thanks JoaquinLR

0 Likes
Anil_Babu_Samineni

Nice Explanation, Thanks AR

avinashelite

Thanks Anil

0 Likes
benmaslen
Explorer
Explorer

Thanks Avinash, just what I needed

v_petrenko
Partner - Contributor III
Partner - Contributor III

Avinash, I've just edited the categories list of this article, if you don't mind. You didn't have to tick all the available categories.

0 Likes
flanfranco
Partner - Contributor III
Partner - Contributor III

This is a greattttt post!!!!
Thanks!!

avinashelite

v.petrenko‌ no issues

0 Likes
spsrk_84
Creator III
Creator III

Good one

0 Likes
avinashelite

Thanks you spsrk_84

0 Likes
Version history
Last update:
‎2014-09-23 06:18 AM
Updated by: