Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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')
.......