topic Re: Crosstable Dates converted to string in QlikView

Crosstable Dates converted to string

Tue, 17 May 2011 04:24:40 GMT

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

Crosstable Dates converted to string

Tue, 17 May 2011 05:38:55 GMT

Hi,

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

Thanks & Regards

Jai

Re: Crosstable Dates converted to string

Tue, 17 May 2011 05:46:15 GMT

Yeah I tried that before but they do nothing to strings

Crosstable Dates converted to string

Tue, 17 May 2011 06:51:08 GMT

Hi,

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

Thanks & Regards

Jai

Re: Crosstable Dates converted to string

Tue, 17 May 2011 06:58:56 GMT

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

Re: Crosstable Dates converted to string

Tue, 17 May 2011 07:09:53 GMT

Hi,

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

Thanks & Regards

Jai

Re: Crosstable Dates converted to string

Tue, 17 May 2011 07:24:10 GMT

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.

Crosstable Dates converted to string

Tue, 17 May 2011 07:26:51 GMT

Cool..No probs...

Thanks & Regards

Jai