1 Reply Latest reply: Sep 7, 2017 5:15 AM by Thomas Le Gall RSS

    How to change Y-axis values Dynamically

    V Kumar

      Hi All,

       

      I am facing issue while creating line chart in Qlik sense.

      here am using set expression please find below

       

      Num(Sum({$<Measure={'Dollars Spent'}, [Month Year]=, Quarter=, [SCML Id]-={},   [Time Period]={$(|||||)} >}Value) / 1000000,'#,##0.00 M$;(#,##0.00 M$)')

      for above expression i have changed Number format is "Money" and Format pattern i have given "M" if i do the changes it is reflecting all charts but i don't want like that i have another set expression's below i have mentioned how to change values as KW-H ,MT and gal.

      '#,##0 kW-h;(#,##0 kW-h)'

      '#,##0 MT;(#,##0 MT)'

      '#,##0 gal;(#,##0 gal)'

       

      please help on this

       

      Thanks in advance