Displaying Millions symbol when axis still has 000's

[lucasdavis500]

How can I make my Millions symbol display, without using a 000's symbol

this is what my chart looks like

When I take K's out of thousands, and Add 'M' into millions, nothing happens, and my numbers expand on the axis to the true value. I.E. 1500 goes to 1,500,000. I believe this is an issue because there are values that are less than a million. How can I get my axis to show .5, 1, 1.5 and the top be 'M'....

[MK9885]

num(YourExpression)/1000000 , '$#,##0.00 M')

[lucasdavis500]

That Formula, coupled with my expression, did not work:

=NUM(IF(CurYTDFlag = '1', Furnishings)/1000000, '$#,##0.00 M')

I have two expressions in my chart.

It's causing the %'s on the Secondary axis to be way higher than they should be, and I didn't even change the formatting for that expression. Also, it did not add M's to signify Millions on the left axis...

[vinieme12]

[MK9885]

It will not add M to the Axis, instead it will add M to the data points on your trend line (if you show values on data points)

[lucasdavis500]

This is great, but how are you getting the values on your axis to switch to millions. They still are represented by full value i.e. 1,500,000 ; 1,000,000 ; 500,000

[lucasdavis500]

[vinieme12]

You will need to divide them /1000000

Just FYI: When you use formatting functions with your expression like NUM(sum(Expression3)/100,'M$#,##0')

               you should check Expression Default in the Number formatting tab(the top most option button) for the formatting to take effect.

So two options

1)  use NUM(sum(Expression3)/100,'M$#,##0') in expression and check Expression Default

2) Normal Expression/1000000  and Check Money formatting and add 'M$'  manually to symbol.

[lucasdavis500]

Again, this method does NOT work with my data.

I have two expressions:

EXPRESSION 1:

IF(CurYTDFlag = 1, FURNISHINGS)

EXPRESSION 2:

=(COUNT({<[Var1_Dummy] = {'0'}, Var2_dummy = {'1'}, Var3_Dummy = {'1'},  Type = {'Vehicle/Home EQ', 'Financial Card'}, Month -= {$(vCurrentMonth)}, CurYTDFlag = {'1'}>} Pkey) +


COUNT({<Var4Dummy = {'1'}, Month -= {$(vCurrentMonth)}, CurYTDFlag = {'1'}>}[Control Number])) / (Furnishings)

View:

Changing EXPRESSION 1:

(IF(CurYTDFlag = 1, FURNISHINGS))/1000000

Results in:

Why is changing the value on ONE axis affecting the values on another? Why is it muliplying my % by 1,000,000. I have in no way altered the formatting of the right axis, or the expression..

[lucasdavis500]

I changed my second expression to:

=((COUNT({<[Var1_Dummy] = {'0'}, Var2_dummy = {'1'}, Var3_Dummy = {'1'},  Type = {'Vehicle/Home EQ', 'Financial Card'}, Month -= {$(vCurrentMonth)}, CurYTDFlag = {'1'}>} Pkey) +


COUNT({<Var4Dummy = {'1'}, Month -= {$(vCurrentMonth)}, CurYTDFlag = {'1'}>}[Control Number])) / (Furnishings) ) / 1000000

and it formatted it back to .4%, .5%, .6%

but why does changing one expression affecting the axis of a totally different expression, that is formatted a different way. it multiplied the other axis by 1,000,000 when I divided the first expression. is this a bug in qlikview?