Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In attachment Point is a date field or number field.
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
In your qlikview use that
date(date#(date,'YYYYMMDD'))
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'))
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
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
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
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
I will share it with you in some time..