topic Re: Removing Negative Signs for Bar Chart in QlikView

Removing Negative Signs for Bar Chart

Wed, 13 Jul 2016 15:35:01 GMT

Hi,

I have created a stacked bar chart with two different sales types (used expression not dimensions). I have used negative sales to divide the sales by origin. Now I want remove negative sign from the texts. Is it possible. For example. Instead of -1385 I want 1385

Re: Removing Negative Signs for Bar Chart

sunny_talwar — Wed, 13 Jul 2016 15:37:54 GMT

May be like this:

Dual(Fabs(YourCurrentExpression), YourCurrentExpression)

Replace YourCurrentExpression placeholder with whatever your expression you are using today.

Re: Removing Negative Signs for Bar Chart

stigchel — Wed, 13 Jul 2016 15:41:19 GMT

Yes you can change the format pattern for that expression in the Number Tab of the chart properties to

#,##0%;#,##0%

Re: Removing Negative Signs for Bar Chart

Wed, 13 Jul 2016 15:44:00 GMT

Yes! works! Thanks