Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 

      

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Crosstable Dates converted to string

Hi,

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

Thanks & Regards

Jai

7 Replies
Not applicable

Crosstable Dates converted to string

Hi,

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

Thanks & Regards

Jai

Not applicable

Re: Crosstable Dates converted to string

Yeah I tried that before but they do nothing to strings

Not applicable

Crosstable Dates converted to string

Hi,

 

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

Thanks & Regards

Jai

Not applicable

Re: Crosstable Dates converted to string

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

Re: Crosstable Dates converted to string

Hi,

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

Thanks & Regards

Jai

Not applicable

Re: Crosstable Dates converted to string

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

Crosstable Dates converted to string

Cool..No probs...

Thanks & Regards

Jai

Community Browser