Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a straight chart , in which i am showing data as both (%, and as normal number) and it is working fine is QlikView.
But when i export the table into excel the data comes in text format in excel.
Please find the attached dummy application. I am using "pick (match" in my scenario to meet my requirements.
Any suggestions and help will be really appreciated.
Regards
KC
I have QV release 11 SR8. Expression is set to fixed number with 2 decimals that is exported using macro to excel cells with format number with 2 decimals. Any advices are not functioning, expression is exported as text. I can say I am desperate for this product.