Discussion Board for collaboration on QlikView Scripting.
I am trying to load data from an excel sheet into Qlikview but when the a crosstable is applied, it changes the date into a string and makes it useless
This is an example of what I am doing. If anyone found a way to bring in date after applying crosstable, please Help!
| 11/01/10 | 11/02/10 | 11/03/10..........
Project x y z
PBIT 20000 300000 100000
Project | Date | PBIT
Go to Solution.
I have checked with Date#() and its giving corresponding month fields.have a look
Thanks & Regards
You can try Date() or Date#() functions for the same.
Yeah I tried that before but they do nothing to strings
Can you attach your application,then it will helpfull for me
Sent: Tuesday, 17 May 2011 4:52 PM
To: Danny Rock
Subject: - Re: Crosstable Dates converted to string
Re: Crosstable Dates converted to string
created by ijprakash<http://community.qlik.com/people/ijprakash> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/116555#116555
Thanks, I must not have properly tried the date#
Btw, I cannot reply on the community, I am having to reply via outlook so am not sure how to elect your answer as being right, for e.g, the Reply link on the community does’nt work, and this time I really tried.