topic Re: use of mini Charts in QlikView

use of mini Charts

Fri, 25 Feb 2011 05:46:47 GMT

Dear All,

Can any one tell me What is the use of Mini Chart as in that Chart we cannot See the Data or vale,

Ex: In my Straight Table i Have Dimension as Customer and Expression as Amount

so in my Mini Chart i am giving Dimension as Port Pair and i Can See the Chart,

But the Valueor Data on Mini Chart Doesnt Come.

Is there any preocess to get the Data on Mini Chart,

And please can any one Clarify any more use of mini Chart as i want to Apply Mini Chart but getting Restriction dure to Less Friendly.

Best Regards,

Pranav

use of mini Charts

deepakk — Fri, 25 Feb 2011 06:32:29 GMT

hi Pranav,

PFA.

use of mini Charts

Fri, 25 Feb 2011 06:39:08 GMT

Hi Pranav,

It is the graphical representation of the data. Yes you are correct you cannot see the data or value. As per me I don't think there is a way to show the data in the mini chart.

So mini chart is just the graphical representation of data which you can show inside a straight table or chart.

Re: use of mini Charts

Tue, 20 Nov 2012 21:24:19 GMT

Note that you can have two columns for your data (two expressions in the straight table chart), one visible as a mini chart and the other with an average value.

Or if you really want both mini charts and the number for each month, you can layer a straight table with mini charts on top of a pivot table with numbers:

Re: use of mini Charts

ramasaisaksoft — Fri, 04 Jul 2014 12:16:12 GMT

Thanks Deepak.

Re: use of mini Charts

Tue, 15 Sep 2015 09:47:27 GMT

Hi Jonathan,

Is it possible to change color of dots depending upon result of expression.

for example

if result of expression is 1 then show dot of line mini chart in GREEN color

if it is 2 then show dot in RED

if it is 3 then show dot in BLUE

if it in 4 then show dot in ORANGE color

Re: use of mini Charts

Tue, 15 Sep 2015 20:31:06 GMT

Unfortunately, no: you can only choose a default color, a max value color, and a min value color. Normally you can write formulae to control these things by expanding the expression in the list of expressions, but setting a calculation for Text Color or Line Style does not change the colors of the whiskers.

Unless maybe they've changed something; I'm using 11.20.

Re: use of mini Charts

Anonymous — Tue, 07 Nov 2017 10:46:00 GMT

Or if you really want both mini charts and the number for each month, you can layer a straight table with mini charts on top of a pivot table with numbers:

Hi jonathan,

I have the similar requirement Can you please explain how the layering is done with straight table,pivot table with mini chart to show month/day wise split-ups?