Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.