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

[sunny_talwar]

Change the format of your field from document properties to show Number

[sunny_talwar]

Or try this:

Table:

LOAD Num([42370]) as [01-01-2016],

  Num([42402]) as [02-02-2016],

  Num([42432]) as [03-03-2016]

FROM

[..\..\..\Downloads\Check - Copy.xlsx]

(ooxml, embedded labels, table is Sheet1);

[trdandamudi]

Please see the attached and hope this helps....

[qlikview979]

Thanks Bro,

its coming , but  with out rename how can i get Date

Regards

[qlikview979]

Thanks Bro,

its coming , but  with out rename how can i get Date

Regards

[arulsettu]

i think renaming is only option here

[qlikview979]

Hi,

With our rename Data is coming but field name coming number  format

[qlikview979]

Hi,

Is it possible ?

[Anil_Babu_Samineni]

Hey, Man use your Listbox number Tab with the format of Date and use [DD-MM-YYYY] and check

[qlikview979]

Hey anil,

i done like that, if i change the number to date my data also converting date format.