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

Crosstable Dates converted to string

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 

      

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

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

Thanks & Regards

Jai

View solution in original post

7 Replies
Not applicable
Author

Hi,

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

Thanks & Regards

Jai

Not applicable
Author

Yeah I tried that before but they do nothing to strings

Not applicable
Author

Hi,

 

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

Thanks & Regards

Jai

Not applicable
Author

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

Not applicable
Author

Hi,

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

Thanks & Regards

Jai

Not applicable
Author

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.

Not applicable
Author

Cool..No probs...

Thanks & Regards

Jai