topic Mirrored bar chart in QlikView in QlikView

Mirrored bar chart in QlikView

Thu, 21 Jul 2016 13:13:59 GMT

Hi Community,

Can we mirror a bar chart in QlikView like below? I'm able to do it in excel, just wondering if the same is possible in QV.

PS> I would like to avoid multiplying the values by -1. I'm aware of this workaround.

Thanks for your time.

-V

sunny_talwar — Thu, 21 Jul 2016 15:26:12 GMT

I think you can use this to create something like what you want:

Gysbert_Wassenaar — Thu, 21 Jul 2016 15:27:25 GMT

Yes, multiply the values by -1 and then use a number format of 0;0 so that negative values will be shown without a - sign.

Thu, 21 Jul 2016 20:00:12 GMT

Thanks Sunny and Wassenaar. Appreciate the help.