Date

[qlikview979]

Hi Experts I have data like this

01-01-2016	02-02-2016	03-03-2016
1	4	7
2	5	8
3	6	9

When i load the data  i am getting fields like

[42370],

[42402],

[42432]

if am using date function its coming correct data , but data is not coming .

Regards

Mahesh

[qlikview979]

I have this  data in Excel .

[sunny_talwar]

Are you doing CrossTable load here? I think you need to use Num#() function to fix this. Look here for a similar discussion we had today:

Re: Date Conversion

[qlikview979]

Hi Sunny,

I am not doing Cross table,  I want Exact Excel format data in table box.

Regards

[arulsettu]

loading your sample i am getting exact match

LOAD * Inline [

01-01-2016, 02-02-2016, 03-03-2016

1, 4, 7

2, 5, 8

3, 6, 9

];

[qlikview979]

Hi ,

I am getting in inline table , but  i am loading Excel file  there i am not getting

Regards

[sunny_talwar]

Then the only option you have is to do this:

[42370] as [01-01-2016],

[42402] as [02-02-2016],

[42432] as [03-03-2016]

[qlikview979]

Hi Sunny,

if i done like this

[42370] as [01-01-2016],

[42402] as [02-02-2016],

[42432] as [03-03-2016]

Getting

[arulsettu]

can you post the excel

[qlikview979]

Hi Please find the attached file