topic Re: send to excel puts date in two different formats in QlikView

send to excel puts date in two different formats

Anonymous — Tue, 15 Apr 2014 18:10:01 GMT

I have a pivot table with Date Column . When I send that table to excel it puts both the date format in that table. I dont want the number format .

I am therefore attaching the images of the same i.e my pivot table(qlik1) and of the excel(qlik2).

Please help me with this

Thanking everyone in anticipation

Re: send to excel puts date in two different formats

its_anandrjs — Tue, 15 Apr 2014 18:14:30 GMT

In attachment Point is a date field or number field.

Re: send to excel puts date in two different formats

Anonymous — Tue, 15 Apr 2014 18:19:01 GMT

point is neither a date field nor a number field its a name field. U can c INTEGRATED Flow written in the next column of Point . That is actually the point Name .. The point field has all its data in the horizontal row

Re: send to excel puts date in two different formats

arsal_90 — Tue, 15 Apr 2014 18:24:42 GMT

In your qlikview use that

date(date#(date,'YYYYMMDD'))

Re: send to excel puts date in two different formats

arsal_90 — Tue, 15 Apr 2014 18:26:53 GMT

Point is date field

40803	9/17/2011
40804	9/18/2011
40805	9/19/2011
40806	9/20/2011
40807	9/21/2011
40808	9/22/2011

date(date#(date,'YYYYMMDD'))

Re: send to excel puts date in two different formats

its_anandrjs — Tue, 15 Apr 2014 18:32:30 GMT

I Believe it is a date field some thing like from excel you can change it like

Date(Date#(Point,'MM/DD/YYYY'))

In your load script

Re: send to excel puts date in two different formats

Anonymous — Tue, 15 Apr 2014 18:35:01 GMT

I dont want anything to be displayed in the Point Column, I t should be blank because all my point data is displayed in the horizontal row

Re: send to excel puts date in two different formats

Anonymous — Tue, 15 Apr 2014 18:35:43 GMT

Hey Ashraf

I dont want anything to be displayed in the Point Column, It should be blank because all my point data is displayed in the horizontal row. I have transposed that particular column

Re: send to excel puts date in two different formats

arsal_90 — Tue, 15 Apr 2014 18:38:36 GMT

i don't understand your requiremet can u elaborate your output in excel file or sare me your qvw. As i can help you

Re: send to excel puts date in two different formats

Anonymous — Wed, 16 Apr 2014 06:17:28 GMT

I will share it with you in some time..