Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

karunpreet
Contributor

send to excel puts date in two different formats

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

9 Replies

Re: send to excel puts date in two different formats

In attachment Point is a date field or number field.

karunpreet
Contributor

Re: send to excel puts date in two different formats

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
Contributor III

Re: send to excel puts date in two different formats

In your qlikview use that

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

arsal_90
Contributor III

Re: send to excel puts date in two different formats

Point is date field

408039/17/2011
408049/18/2011
408059/19/2011
408069/20/2011
408079/21/2011
408089/22/2011

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

Re: send to excel puts date in two different formats

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

karunpreet
Contributor

Re: send to excel puts date in two different formats

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

karunpreet
Contributor

Re: send to excel puts date in two different formats

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
Contributor III

Re: send to excel puts date in two different formats

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

karunpreet
Contributor

Re: send to excel puts date in two different formats

I will share it with you in some time..

Community Browser