topic Re: Box plot chart in QlikView

Box plot chart

Mon, 10 Mar 2014 20:49:00 GMT

Hi All,

How to create a box plot chart in Web version of qlikview? I am able to achieve it in desktop version but not sure in web version.

Your responses would be highly appreciated.

Thanks,

Re: Box plot chart

Mon, 10 Mar 2014 21:47:02 GMT

Need your input Gurus.

Re: Box plot chart

jaimeaguilar — Mon, 10 Mar 2014 22:22:46 GMT

Hi, box plot chart is a native chart inside QlikView (although it is not so well-known). So it means that you should be able to use it either in Webview, Desktop or IE plug-in,

regards

Re: Box plot chart

Mon, 10 Mar 2014 22:26:09 GMT

Thanks Jaime..Can you please help me in creating the chart from web view?

I am able to create in desktop version and deploy the document into server and view in web view. My users who has only access to qlikview web wants to create this chart and couldn't find the option.

Thanks,

Re: Box plot chart

Clever_Anjos — Tue, 11 Mar 2014 01:40:15 GMT

Try the wizard, it works both WebView or Normal View

Re: Box plot chart

Tue, 11 Mar 2014 01:51:25 GMT

I want to create directly from Web view not from Desktop.

Re: Box plot chart

Clever_Anjos — Tue, 11 Mar 2014 01:55:43 GMT

I don´t think is supported

Re: Box plot chart

jaimeaguilar — Tue, 11 Mar 2014 02:09:02 GMT

mrcool4u wrote:

I want to create directly from Web view not from Desktop.

I Think you have to créate it in desktop and then you can edit some properties from webview. However, I don't think it's possible to create a new box plot from webview

Re: Box plot chart

Tue, 11 Mar 2014 04:19:15 GMT

How to get text pop up on box plot chart??

Re: Box plot chart

Tue, 11 Mar 2014 20:25:04 GMT

Please help me in plotting values on box plot chart.

Thanks,

Re: Box plot chart

Anonymous — Tue, 11 Mar 2014 20:43:32 GMT

I don't think it's possible. Possibly by purpose. Box plot has five values, it would be quite messy to show.

Re: Box plot chart

Tue, 11 Mar 2014 20:46:14 GMT

Thanks Michael..Is it possible to show as pop up text?? Without out any values users are finding hard to know the exact value.

Thanks,

Re: Box plot chart

Anonymous — Wed, 12 Mar 2014 00:39:47 GMT

The pop-up option is not available. Best case probably is to create an invisible expression there and use it for numbers on axes. But it would be only one number, not five.

Re: Box plot chart

Wed, 12 Mar 2014 00:45:11 GMT

I tried so many options but nothing works. I think qlikview has to provide an easy option to show all the 5 values.

I have followed last option in this thread but no luck:

Values on Data Points in a Box Plot Chart

Re: Box plot chart

Wed, 12 Mar 2014 04:58:26 GMT

Please let me know if there are any other options available?

Thanks,

Re: Re: Box plot chart

Anonymous — Wed, 12 Mar 2014 17:45:35 GMT

I didn't see the post you mentioned, going to try later. For now, see my test with "text on axis". I used only three expressions here:

Re: Re: Box plot chart

Wed, 12 Mar 2014 20:42:16 GMT

Thanks Michael Solomovich .. I will wait for your Solution.

Re: Box plot chart

Anonymous — Thu, 13 Mar 2014 14:17:08 GMT

I tried solution offered by Gabriel Gejman in the link you provided earlier - it worked beautifully

In my test, I added the bar expression (it must be on top) with the label

='Upper Whisker: ' & fractile({<Actual={'>0'}>} Actual, 0.8)

&chr(10)&

'Top: ' & fractile({<Actual={'>0'}>} Actual, 0.75)

&chr(10)&

'Median: ' & median({<Actual={'>0'}>} Actual)

&chr(10)&

'Bottom: ' & fractile({<Actual={'>0'}>} Actual, 0.25)

&chr(10)&

'Lower Whisker: ' & fractile({<Actual={'>0'}>} Actual, 0.1)

and expression definition

fractile({<Actual={'>0'}>} Actual, 0.8)

(it covers area from 0 to the top of the upper whisker, you may want to limit it as in the original post)

Background color - used blue(0). It could be any color but transparent, hence 0 here.

Regards,

Michael

Re: Re: Box plot chart

Thu, 13 Mar 2014 20:31:19 GMT

Thank you so much Michael Solomovich .can you please send me the screenshot of your settings/properties..I tried the same but didn't work..Same value repeats across all the bars.

Thanks,

Re: Re: Box plot chart

Anonymous — Fri, 14 Mar 2014 13:05:57 GMT

...Same value repeats across all the bars.

You're right, I wasn't careful - label calculates over all data, not per dimension value.
This makes more sense:

Label is blank. Use space, otherwise expression itself will be shown as label.

Expression definition, in my case:

=dual(

// text to show in pop-up:

chr(10)& // to move the text below the "=" sign; can't remove it

'Upper Whisker: ' & fractile({<Actual={'>0'}>} Actual, 0.8)

&chr(10)&

'Top: ' & fractile({<Actual={'>0'}>} Actual, 0.75)

&chr(10)&

'Median: ' & median({<Actual={'>0'}>} Actual)

&chr(10)&

'Bottom: ' & fractile({<Actual={'>0'}>} Actual, 0.25)

&chr(10)&

'Lower Whisker: ' & fractile({<Actual={'>0'}>} Actual, 0.1)

// value for the bar height:

fractile({<Actual={'>0'}>} Actual, 0.8)

)

All ther other properties are the same. Hope this is close to what you need...

Regards,

Michael