Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
how can i do that?
lets say i have a diagramm showing costs in million of $, but instead of having them represented like this: $ 7800000, i wanna have them like this: $5,8M
thanks!
Correct.
With European formats you need to change the formula.
In my test I used:
=Num(Sum(KM)/1000000, '#.### M', ',', '.')
For your formula I suggest:
Num(Sum({<Store={'AME'}>} Sales) / 1000000, '#.### M', ',', '.')
Fabiano
Hello @Nemo1 ,
I suggest this formula
=Num(Sum(<Expression>)/1000000, '#,### M', '.', ',')
Note: the number format if for North America, with "." for decimal separation and "," for thousand separation.
Regards
Fabiano
it is not working, the formula looks like this at the end:
Num(Sum({<Store={'AME'}>} Sales) / 1000000, '#,### M')
maybe the problem lies in the fact that i am in europe, and not in the US?
Correct.
With European formats you need to change the formula.
In my test I used:
=Num(Sum(KM)/1000000, '#.### M', ',', '.')
For your formula I suggest:
Num(Sum({<Store={'AME'}>} Sales) / 1000000, '#.### M', ',', '.')
Fabiano
accidentaly i pressed to accept the solution, it is still not working, i dont get the M 😞
To represent costs in millions of dollars in the format "$5.8M" instead of "$7800000", you can follow these steps:
Divide the Cost by One Million: First, divide the cost value by one million to convert it to a decimal. For example, if the cost is $7,800,000, divide it by 1,000,000 to get 7.8.
Format the Decimal as "M": Once you have the decimal value representing millions, append "M" to indicate million. So, 7.8 becomes "$7.8M". Also, check out Baweja Media.
I have already divided by 1000000, i dont know how to append the M
I tried to simulate your problem, but always got the M. (I also tried with a set expression).
Which version of Qlik Sense are you using?
Can you post a picture of the resulting graph?
Regards
Fabiano