topic Split chart with single expression in QlikView

Split chart with single expression

Peter_Cammaert — Fri, 03 Sep 2010 11:49:53 GMT

Hi,

a question for a very common problem. I hope that QlikView has some hidden switch/magic for making this presentable.
I have this chart:

The peak value makes the other bars scale down to almost invisible. In printed/electronic media, the graphics department transforms the graph into something like this:

Is this possible in QlikView?

Thanks, Peter

Split chart with single expression

johnw — Fri, 03 Sep 2010 23:56:02 GMT

I don't think it can do that directly. But you can put two bar charts with different static min and max on top of each other. Dress it up a little with some lines, and call it good. You can use expressions for the static min and max for each chart if you don't know what sort of data range to expect. See attached.