Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
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
Crosstable applied
Project | Date | PBIT
X 11/01/10
11/02/10
Y 11/01/10
11/02/10
Z 11/01/10
11/02/10
Hi,
I have checked with Date#() and its giving corresponding month fields.have a look
Thanks & Regards
Jai
Hi,
You can try Date() or Date#() functions for the same.
Thanks & Regards
Jai
Yeah I tried that before but they do nothing to strings
Hi,
Can you attach your application,then it will helpfull for me
Thanks & Regards
Jai
Sent: Tuesday, 17 May 2011 4:52 PM
To: Danny Rock
Subject: - Re: Crosstable Dates converted to string
QlikCommunity<http://community.qlik.com/index.jspa>
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
Hi,
I have checked with Date#() and its giving corresponding month fields.have a look
Thanks & Regards
Jai
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.
Cool..No probs...
Thanks & Regards
Jai