send to excel puts date in two different formats

[Anonymous]

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

[its_anandrjs]

In attachment Point is a date field or number field.

[Anonymous]

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

[arsal_90]

In your qlikview use that

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

[arsal_90]

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'))

[its_anandrjs]

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

[Anonymous]

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

[Anonymous]

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

[arsal_90]

Hi

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

[Anonymous]

I will share it with you in some time..