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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele
Contributor
Contributor

Problem with data format in QLIK Sense Desktop

Hello.

I have a problem with data format.

After the setting in data manager, i cannot view the field in a table of analysys (see 3 images in attachment)

How can I solve it?

Thank you, Gabriele.

 

i see correclyy in data manageri see correclyy in data manager

 

setting in data managersetting in data manager

 

 

in analysys i cannot see the value of datain analysys i cannot see the value of data

 
2 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hello Gabriele,

 

Can you change it so the input format is 'DD/MM/YYYY'?

Seems you are setting the input format to a format that doesn't match the field contents.

 

I hope that helps!

 

Kind regards,

S.T.

jerifortune
Creator III
Creator III

Try explicitly format the date  on the load script

Load
DATE(FLOOR(CRMData),'DD/MM/YYYY')
.......