Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vinod2086
Contributor II

How to change Y-axis values Dynamically

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

1 Reply
thomaslg_wq
Contributor III

Re: How to change Y-axis values Dynamically

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