topic Re: Flip Y Axis in QlikView

Flip Y Axis

Anonymous — Tue, 28 Feb 2017 21:25:16 GMT

I need to flip the Y axis in the chart below so it goes from 80 at the bottom and 0 at the top.

Seems like it should be easy but I haven't found an easy answers.

Thank you,

- dave

Re: Flip Y Axis

vishsaggi — Tue, 28 Feb 2017 22:04:12 GMT

Just use in your expression like

= - Count(Yourfieldname)

= Count(YourfieldName) * -1

Re: Flip Y Axis

Anonymous — Wed, 01 Mar 2017 13:26:27 GMT

I tried below and neither worked ...

Count([Blended Rank])*-1

and

- Count([Blended Rank])

Re: Flip Y Axis

vishsaggi — Wed, 01 Mar 2017 14:19:08 GMT

Can you share your app if possible?

Re: Flip Y Axis

avinashelite — Wed, 01 Mar 2017 14:28:01 GMT

try this

Dula(Count([Blended Rank]),Count([Blended Rank])*-1)

Re: Flip Y Axis

Anonymous — Wed, 01 Mar 2017 14:37:06 GMT

App is huge so I cannot share

Re: Flip Y Axis

Anonymous — Wed, 01 Mar 2017 14:37:30 GMT

Didnt work but thank you

Re: Flip Y Axis

avinashelite — Wed, 01 Mar 2017 14:39:35 GMT

It should work ...do you have any other expressions ? with that ..could you please share the screen shot ??

Re: Flip Y Axis

vishsaggi — Wed, 01 Mar 2017 14:40:15 GMT

I am not sure why it is not doing, can you build some sample data from that dashboard with less data and share? Is that easy to do ?

Re: Flip Y Axis

Anonymous — Wed, 01 Mar 2017 15:08:48 GMT

=-Sum([Blended Rank]) worked for me after a little work ... Thank you for all the help!!

Re: Flip Y Axis

apriletaylor — Fri, 10 Mar 2017 11:40:01 GMT

I'm using the same type of formula for a chart showing rank and this has solved the 0 at the top problem. Is there a away to get the negative numbers on the rest of the axis to show as positives i.e. 20 rather than -20 etc?