topic Re: Graph Negative values Above Line in QlikView

Graph Negative values Above Line

Fri, 25 Oct 2013 10:35:07 GMT

Hi All

I am having issues getting the below graph to put the negative values above the x axis.

Can anybody help ?

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 10:42:05 GMT

Hi,

If you split aixes (aixes tab) inside a combo chart, and your line expression is sent to position right, you will get it.

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 10:43:39 GMT

use bar offset

open expression tab-select expression-expand it-bar offset

if(sum(sales)>0,max(sales))

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 11:01:42 GMT

I am getting this after both of your suggestions

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 11:10:14 GMT

Yes, that´s what you asked for..

Could you explain a little more what´s the goal please ?

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 11:15:16 GMT

I basically want the Secondary axis to also be above the X axis instead of below it

Re: Graph Negative values Above Line

Fri, 25 Oct 2013 11:26:28 GMT

In the aixes tab uncheck forced to zero.

Re: Graph Negative values Above Line

Wed, 27 Nov 2013 11:13:33 GMT

this is fine, but (using your example) I want the secondary axis to read ; -20, -40, -60 incrementally going up the secondary axis rather than down the secondary axis.

Re: Graph Negative values Above Line

Wed, 27 Nov 2013 13:21:54 GMT

Has anybody else got ideas on this one?

Thanks in advance