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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

String

Dear All,

I am loading one QVD in qlikview ,one field having value 1-3-6 but it is not date format ,

how can i display in front end as it is 1-3-6 like numeric format

Thanks In Advance

Niranjan

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Force the loading of the field as text using:

LOAD Text(myField) As myField,

     ...

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

which one is day month and year in the above value ??

-Nilesh

NavinReddy
Creator II
Creator II
Author

Hi Nilesh,

It is not date ,but qlikview treated  like date format, but i need to display same like (1-3-6) in front end

Regards,

Niranjan

nilesh_gangurde
Partner - Specialist
Partner - Specialist

can you please attach the sample qvw.

-Nilesh

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Force the loading of the field as text using:

LOAD Text(myField) As myField,

     ...

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Jonathans suggestion should work, please give feedback and mark the question as answered, so other people with similar problems can find it