Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
KIdriss
Contributor II
Contributor II

Bar chart format and scale with two mesures

Hello,

I have a bar chart, I added two mesures and one dimension.  I multiplied by -1 a mesure. I have bars on the right and left In the format I added '# ##0;# ##0' so that the values ​​are without the negative symbol but it doesn't work.  The values ​​on the left are not on the same scale as the values ​​on the right. How can I adjust the scale at the left?

Capture.PNG

Labels (1)
  • Chart

4 Replies
Mark_Little
Luminary
Luminary

I don't think you can achieve what you want with that approach.

I think you will need to put each measure on it own axis

KIdriss
Contributor II
Contributor II
Author

Hello,

ok, how can i remove negative symbol ?

N30fyte
Creator
Creator


@KIdriss wrote:

how can i remove negative symbol ?


Set number formatting for your measure to Custom, then use this:

#,##0;#,##0

This forces all values to be displayed without a negative symbol.

 

non-negative negatives.png

Kudos to @swuehl in this thread for the hint.

KIdriss
Contributor II
Contributor II
Author

hello,

thank for your help.