Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Date

Hi Experts I have data like this

 

01-01-201602-02-201603-03-2016
147
258
369

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

24 Replies
qlikview979
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Hi Sunny,

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

Regards

arulsettu
Master III
Master III

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Hi Sunny,

if i done like this

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

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

[42432] as [03-03-2016]



Getting


Untitled.png

arulsettu
Master III
Master III

can you post the excel

qlikview979
Specialist
Specialist
Author

Hi Please find the attached file