How to change Y-axis values Dynamically

[vinod2086]

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

[thomaslg_wq]

Hi,

Not really clear.

If you let your format as auto and not number, and use the format num function [num(----,'format')] as you do in your expression, it sould always work whatever the expression in the measure.

BR,

Thomas