topic Re: Mini charts static min and max axis alignment in QlikView

Mini charts static min and max axis alignment

Anonymous — Sun, 20 Sep 2015 13:39:16 GMT

Hi all,

My mini charts are pretty flat in comparison and will to make the MoM variance stand out.

We know that scale (static min and max) value of the chart can be adjusted axes under chart properties.

The options are limited in the mini chart settings.Not sure if this can be done for mini charts using SET analysis in the expression.

Regards,

Nelson

Re: Mini charts static min and max axis alignment

Oleg_Troyansky — Sun, 20 Sep 2015 19:25:51 GMT

Hi Nelson,

you can address it in a few ways:

1. Play with the two checkboxes at the bottom of the Mini-cart settings, they can help you emphasize the trend if the mini-charts don't have to be scaled, compared to each other.

2. If you'd like to add a static minimum, simply subtract the value from your mini-chart expression, like this:

Sum(Sales) - 1000000

or using a variable:

Sum(Sales) - $(vMyStaticMin)

In this case, you don't need to worry about the static Max - QlikView will automatically scale the highest value in the chart to take up the available space.

3. If you'd like your Min value to be dynamic, you can try to calculate it using advanced aggregation. For example, if your chart is by Customer, then this will be the min value of sales by Customer:

min(

AGGR(

sum(Sales)

, Customer

)

Now, you can subtract this value from the chart expression. This way, the min. value of Sales will be equivalent to 0 in your mini chart. You can tweak it to show an arbitrary small amount in this case.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Mini charts static min and max axis alignment

Anonymous — Fri, 25 Sep 2015 09:10:51 GMT

Hi Oleg,

Thanks for offering the various alternative solutions. I have tried option 1 & 2 and the visual results is more or less the same.

Option 3 looks viable and below is the link for those looking for solutions.

Data Driven Dynamic Static Max value in Charts

Cheers,

Nelson