by using the default expression formatting, the result in excel will be raw value, without your specific num function formatting applied. I am not sure there is a native way to stop this from happening.
One option you might consider is to have an expression for each of the possible types of value you will use, and then conditionally enable the relevant expression when it's type is used (so only one is enabled at a time).
You can then set the formatting within the chart itself rather than default expression and when you then export out to excel the expression will have the formatting you want.
Hope that helps
Yes that solution you provided is the only one i also thought at the moment as possibile solution, the only problem is i have another report with multple dynamic expressions and I could end up with many expressions in a single chart maybe affecting the performance, i will have to test it in advance.
Anyway if i can't find any other "trick" (like the Money() function for example) i think that one is the only option.
Unfortunately I think Qlikview manages these types at a lower level, so the the only way is to set them directly.
Thank you very much for your help, really appreciated.
from a tidiness point of view you obviously don't want to have to many expressions yes, but from a performance point of view doing this shouldn't have a big impact, as if you have 3 'types' you will have the exact same expression for each expression, so still the caching benefit there.
The extra overhead will come in the form of a conditional expression you will have to put for each one, which should be negligible.