topic Calendar Object in QlikView

Calendar Object

Tue, 07 May 2013 08:41:26 GMT

Hello,

I want to get the data in between to dates.

using the Calendar Object

Attaching the files.

Thanks and Regards,

Priya

Sokkorn — Tue, 07 May 2013 08:54:45 GMT

Hi priya,

Your set analysis will not work due FinalDate in format MM/DD/YYYY and vFromDate in number fomat.

My suggestion is create a new field for Set Analysis

Directory;

LOAD [First Name],

[Second Name],

Address,

Designation,

Sal,

Date(Date,'DD/MM/YYYY') as FinalDate,

Floor(Date) AS [_FinalDate]

FROM

Book1.xlsx

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

============================================

And use this set analysis Sum( {$<[_FinalDate] = {">$(vFromDate)<$(vToDate)"}>} Sal)

Regards,

Sokkorn

Tue, 07 May 2013 09:06:33 GMT

Thanks for the reply.

Can u please rectify my qvw

Sokkorn — Tue, 07 May 2013 09:11:38 GMT

FYI