Crosstable Dates converted to string

[#1]

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 

[#2]

Hi,

    You can try Date() or Date#() functions for the same.

Thanks & Regards

Jai

[#3]

Yeah I tried that before but they do nothing to strings

[#4]

Hi,

   Can you attach your application,then it will helpfull for me

Thanks & Regards

Jai

[#5]

From: ijprakash

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

[#6 · Accepted solution]

Hi,

     I have checked with Date#() and its giving corresponding month fields.have a look

Thanks & Regards

Jai

[#7]

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.

[#8]

Cool..No probs...

Thanks & Regards

Jai