Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sent to excel problem

hi i having a difficulties please help me to solve it thanks 🙂

when i click sent to excel my other customer code is changing format into date 

please see attached to visualize

6 Replies
its_anandrjs
Champion III
Champion III

Hi,

It seems you have not proper format for the customer code or may be there are some rows have date values please check this. For more details please share sample file.

Regards

Anand

Not applicable
Author

sir in my qlikview app there are no customer code that has date values , and i already format the customer code please see attached my screenshot of script. thanks for the help 🙂CustomerFrmat.jpg

its_anandrjs
Champion III
Champion III

Hi,

And in source file what is format that you check, or can i have a look the QVD file also.

Regards,

Anand

Not applicable
Author

sir can i get your email so i can sent you personally the qvd file. thanks

jpenuliar
Partner - Specialist III
Partner - Specialist III

Pare,

Can you compare which rows in excel are formatted as Date and the actual values in qlikview.

Not applicable
Author

this is the example

comparison.jpg