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

Announcements
We are aware of an issue with the Product Downloads page and looking into it.
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

Labels (1)
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