Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
its_anandrjs

In attachment Point is a date field or number field.

Anonymous
Not applicable
Author

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

In your qlikview use that

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

arsal_90
Creator III
Creator III

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

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
Not applicable
Author

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
Not applicable
Author

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

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
Not applicable
Author

I will share it with you in some time..