topic Re: Dates in QlikView

Dates

bharatkishore — Tue, 27 Dec 2011 10:29:33 GMT

Hello All,

Can anyone tell me how to get the dates in qlikview. Date is not generating.I am new to qlik view.

Dates

Sokkorn — Tue, 27 Dec 2011 10:50:42 GMT

Hi,

I'm not sure what you want yet. But let check this for idea http://community.qlik.com/qlikviews/1001

Regards,

Sokkorn Cheav

Dates

Anonymous — Tue, 27 Dec 2011 10:54:29 GMT

Assuming you have a date-field in your loaded data there are sevarel ways to create the dates you want.

The easiest ways (maybe a good thing to start with is to add some fields you want to your loading script.

To start with try the following:

Year(Datefield) as Year

Month(DateField) as Month
Day(DateField) as Day

If this works depends on the format of the date in your date field.
Let me know if this working and if this is what you are looking for, ok?

Good Luck,

Dennis.

Dates

bharatkishore — Tue, 27 Dec 2011 10:56:41 GMT

Actually I Created an excel sheet and i have took the date fields and names.I saved in qvd file format. My question is i want to get the data.

If i want one day of data i need to get one day of data n if i want to get 10 days of data i need to get 10 days of data.Can u pls solve my question.

Dates

bharatkishore — Tue, 27 Dec 2011 11:02:35 GMT

Thanks Dennis for the reply.

But my question is different.I took an Excel sheet and added 3 dates with names A,B,C.And i saved it n i converted into Qvd File Format.

Again in that excel sheet i added two more dates with names D,E.I saved it in qvd file.Now i concatenated both by incremental load process.

Now if i click i need to get one day of data n if i want to get 10 days of data i need to get 10 days of data or if i wanna get 30 days of data i need to get 30 days of data.

Dennis can u pls solve my query?

Re: Dates

Sokkorn — Tue, 27 Dec 2011 11:03:24 GMT

Hi,

Here is the sample

[Data1]:
LOAD 
    [ID], 
    DateField
FROM [FilesPath\File1.qvd] (qvd)
WHERE [DateField]='27-12-2011';

[FilePath] : Your QVD file location

Edit: You can use wizard in Script by Click on <Table Files> ==> Browse QVD file ==> Filter what you want.

Regards,

Sokkorn Cheav

Re: Dates

bharatkishore — Tue, 27 Dec 2011 11:18:55 GMT

Thanks a lot.....