topic Re: PROBLEM IMPORTING DATA SYMBOLS in QlikView

PROBLEM IMPORTING DATA SYMBOLS

inigoelv — Mon, 03 Jun 2013 15:41:02 GMT

Hello:

I have a problem importing data from a program.

When I import the data the result is:

23/03/2008

24/03/2008

26/03/2008

29/03/2008

30/03/2008

31/03/2008

I can not modify in the origin the dates,

When I filter in excell the data appears as:

□26/03/2008

How can solve this problem and eliminate the symbol?

Thanks in advance

Re: PROBLEM IMPORTING DATA SYMBOLS

Mon, 03 Jun 2013 15:43:19 GMT

Try with this in the load script:

Load:

date(Date,'DD/MM/YYYY') as DateNew

Re: PROBLEM IMPORTING DATA SYMBOLS

ariel_klien — Mon, 03 Jun 2013 15:48:00 GMT

Hi,

Try to use Date(Trim(FiledName),'DD/MM/YYYY') in the script.

Ariel

Re: PROBLEM IMPORTING DATA SYMBOLS

inigoelv — Mon, 03 Jun 2013 15:55:43 GMT

Sorry, the result is the same.

Re: PROBLEM IMPORTING DATA SYMBOLS

inigoelv — Mon, 03 Jun 2013 15:55:57 GMT

Sorry, the result is the same.

Re: PROBLEM IMPORTING DATA SYMBOLS

Mon, 03 Jun 2013 16:04:24 GMT

try this:

Date(PurgeChar(FieldName,'□'),'DD/MM/YYYY')

Re: PROBLEM IMPORTING DATA SYMBOLS

inigoelv — Mon, 03 Jun 2013 16:22:13 GMT

Sorry, the result is the same.

I attached the data in excell to check by yourself.

Re: PROBLEM IMPORTING DATA SYMBOLS

inigoelv — Mon, 03 Jun 2013 16:24:23 GMT

Hi again:

I attach the file for understanding better the problem.

Best regards,

Re: PROBLEM IMPORTING DATA SYMBOLS

shree909 — Mon, 03 Jun 2013 16:32:36 GMT

Hi ,

As far as i understand the date

26/03/2008 is differnet from the other dates

3/29/2008

3/30/2008

3/31/2008

4/1/2008

4/2/2008

4/3/2008

4/4/2008

4/5/2008

4/6/2008

4/7/2008

4/8/2008

4/9/2008

4/10/2008

so either u need to have all the dates in the same format or try to convert eveything into one format,

if ur getting differnt date formats in one date filed u can use alt function

Date(alt(date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'DD/MM/YY' ),'MM/DD/YYYY') as Date in script.

Thanks

Re: PROBLEM IMPORTING DATA SYMBOLS

Mon, 03 Jun 2013 16:38:58 GMT

Try this:

if(len(trim(Date))>10, date(if(SubField(Date,'/',1)=2,SubField(Date,'/',1),right(SubField(Date,'/',1),2))&'/'&SubField(Date,'/',2)&'/'&SubField(Date,'/',3),'DD/MM/YYYY'),Date)as Date

Re: PROBLEM IMPORTING DATA SYMBOLS

er_mohit — Mon, 03 Jun 2013 17:56:42 GMT

I think the issue is in your excel format all dates are in one format thats why in qlikview it understand and give desired output except this format because in qlikview it seems like a string so, you have to 1stly set your excel data in one format

hope it helps