Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Issue with Date

Hi All, I have an excel file containing attendance records of all employees in the format specified below.

   

Employee #NamesTeam NameDesignationWork status01-Jan-16 Fri02-Jan-16 Sat03-Jan-16 Sun04-Jan-16 Mon05-Jan-16 Tue06-Jan-16 Wed07-Jan-16 Thu
1PriyaITAnalystActivePPPPPPP
2PriyankaITAnalystActiveAAAAPPP
3MonikaFinanceAnalystActivePPPPPPP
4SarveshAdminAnalystActivePPPPPPP

And I want it to load it in below format

   

Employee #NamesTeam NameDesignationWork statusDateAtt_Value
1PriyaITAnalystActive01/01/2016P
2PriyankaITAnalystActive01/01/2016A
3MonikaFinanceAnalystActive01/01/2016P
4SarveshAdminAnalystActive01/01/2016P
1PriyaITAnalystActive02/01/2016P
2PriyankaITAnalystActive02/01/2016A
3MonikaFinanceAnalystActive02/01/2016P
4SarveshAdminAnalystActive02/01/2016P
1PriyaITAnalystActive03/01/2016P
2PriyankaITAnalystActive03/01/2016A
3MonikaFinanceAnalystActive03/01/2016P
4SarveshAdminAnalystActive03/01/2016P
1PriyaITAnalystActive04/01/2016P
2PriyankaITAnalystActive04/01/2016A
3MonikaFinanceAnalystActive04/01/2016P
4SarveshAdminAnalystActive04/01/2016P
1PriyaITAnalystActive05/01/2016P
2PriyankaITAnalystActive05/01/2016P
3MonikaFinanceAnalystActive05/01/2016P
4SarveshAdminAnalystActive05/01/2016P
1PriyaITAnalystActive06/01/2016P
2PriyankaITAnalystActive06/01/2016P
3MonikaFinanceAnalystActive06/01/2016P
4SarveshAdminAnalystActive06/01/2016P
1PriyaITAnalystActive07/01/2016P
2PriyankaITAnalystActive07/01/2016P
3MonikaFinanceAnalystActive07/01/2016P
4SarveshAdminAnalystActive07/01/2016

P

But the issue I am facing is with the date column. It is getting loaded in number format. I tried converting it into date format using date and date# function but couldn't achieve desired result.

I need your suggestions.

Thanks in advance

-Priyanka

Tags (2)
20 Replies
ajsjoshua
Valued Contributor

Re: Issue with Date

Hi,

while loading the excel after clicking the Embedded labels click Cross Table

and enter the Qualifier fields ,attribute fields and data field.

sasikanth
Valued Contributor III

Re: Issue with Date

For the desired format use CrosTable load

Cross Table(Date,Att_value,5)

Load * from Excel;

Please attach sample data

MVP
MVP

Re: Issue with Date

Using Crosstable(), you could get that. Try to share a sample excel which we can work upon.

Not applicable

Re: Issue with Date

Tresesco - I am not getting option to attach sample file.

MVP
MVP

Re: Issue with Date

Click on Reply-> Use advanced editor (top right) ->Attach (bottom right)

Not applicable

Re: Issue with Date

Hi,

I am not getting Attach option.please see below screenshot.

Re: Issue with Date

Hi,

Check the attachment.

Capture.PNG

Edit: Sorry, Missed to change the date format. Attached new file against your data.

MVP
MVP

Re: Issue with Date

It seems the option is not somehow not appearing for you. You might have to contact community admin CommunityAdmin‌ or sli

Untitled.png

Chanty4u
Esteemed Contributor III

Re: Issue with Date

u can open ur discussion in seperate tab then only u will find right side top advnced editor

right bottom u will ffind attach

Community Browser