topic Re: Issue with Text() conversion in QlikView

Issue with Text() conversion

anagharao — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a comments column which might have dates like 'Oct-14' or '14-Oct-2016'. I would like to keep them in this format and not as a date.

For this I used Text() function, however the result is not as required. Any solution to this?

Please find the excel and QVW attached.

Regards,

Anagha

Re: Issue with Text() conversion

Kushal_Chawda — Fri, 10 Jun 2016 06:42:51 GMT

what is the Data & what is the expected output? I am not able to open QVW as I don't have QV in my system

Re: Issue with Text() conversion

arasantorule — Fri, 10 Jun 2016 06:56:49 GMT

Hi,

I understand that, this issue is a source data format issue.

In excel 'Oct-14' is in date format and the value of the cell in excel is '1/10/2014'.

Please try to change the column property in excel as text and change the value from '1/10/2014' to 'Oct-14'.

Hope this helps.

Thanks.

Re: Issue with Text() conversion

pho3nix90 — Fri, 10 Jun 2016 07:41:37 GMT

Hi,

This is an excel issue, excel stores actual dates in a 5 digit numerical value, when you are converting it to text it is returning the data as "raw" data. This will only ever happen when the field only contains a date.

See attached, for the example it should work.

Re: Issue with Text() conversion

MK_QSL — Fri, 10 Jun 2016 07:43:56 GMT

Change this variable at the start of this script..

SET DateFormat='DD:MM:YYYY';