topic Re: Date in QlikView

Date

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:02:27 GMT

I have this data in Excel .

Re: Date

sunny_talwar — Mon, 01 Aug 2016 11:05:18 GMT

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

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:10:56 GMT

Hi Sunny,

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

Regards

Re: Date

arulsettu — Mon, 01 Aug 2016 11:12:21 GMT

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

];

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:14:12 GMT

Hi ,

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

Regards

Re: Date

sunny_talwar — Mon, 01 Aug 2016 11:14:17 GMT

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]

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:17:11 GMT

Hi Sunny,

if i done like this

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

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

[42432] as [03-03-2016]

Getting

Re: Date

arulsettu — Mon, 01 Aug 2016 11:18:39 GMT

can you post the excel

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:21:19 GMT

Hi Please find the attached file

Re: Date

sunny_talwar — Mon, 01 Aug 2016 11:23:36 GMT

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

Re: Date

sunny_talwar — Mon, 01 Aug 2016 11:25:16 GMT

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);

Re: Date

trdandamudi — Mon, 01 Aug 2016 11:27:48 GMT

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

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:29:53 GMT

Thanks Bro,

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

Regards

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:30:32 GMT

Thanks Bro,

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

Regards

Re: Date

arulsettu — Mon, 01 Aug 2016 11:32:11 GMT

i think renaming is only option here

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:36:12 GMT

Hi,

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

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:39:54 GMT

Hi,

Is it possible ?

Re: Date

Anil_Babu_Samineni — Mon, 01 Aug 2016 11:40:40 GMT

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

Re: Date

qlikview979 — Mon, 01 Aug 2016 11:44:09 GMT

Hey anil,

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