Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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