8 Replies Latest reply: Jul 20, 2017 4:23 AM by Edward Kirk RSS

    Number recognised as money rather than normal number

    Edward Kirk

      Hi,

       

      I'm using a combi chart to show two measures against each other on the same axis, one as bars and the other as markers. Qlik Sense seems to recognise the bars measure as a normal number, so when Number Formatting is set to "Auto" twenty million is displayed as 20M. However, the second measure is, I think, recognised by Qlik Sense as money which means that the axis displays 20000000, which looks messy and takes up too much space.

       

      How do I get Qlik to treat the second field the same way as the first?

       

      They both come from a SQL database. One thought that I had was that the second field has a $ sign in the column title, so perhaps that triggers something, but i would rather not have to get that changed.

       

      Thanks!