Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I Have qv11.0 ,now i have a problem when i export a pivot table report to xl if a column contains a value both numeric and text data,wherever numeric data is there am getting "number stored as text" in excel,if i changed it as number in report then am not getting any symbol like $,euro etc. pls help me out.
Qlikview can't export formatting. So you either get it as text or as numbers without formatting. You could use a macro to export to excel and create the formatting in the macro. See here for an example. Adjusting the formatting in excel manually is probably faster and easier.
Thanks Sir. Is this Bug?
Have you tried placing num() around your expression? This is what I've had to do as a work around.
Yes sir, if i changed it as number in report then am not getting any symbol like $
How about : num(yourfield,'$####.##') or so?