Add date condition in excel export

[anuradhaa]

I have a CSV file and it has date format as 'd-mmm-yy' (9-Jan-11 etc). I want to use date in where clause when export this data to qlikview.

say i want date > '1-Jan-2016' how can i do that.

[jagan]

Hi,

It is not possible to limit the data while exporting to Excel, it just exports whatever data is available in the chart.  To overcome this create a button and apply the file and then export using macro.

Useful Qlikview Macros

Regards,

jagan.

[PrashantSangle]

Hi,

Load *

from file

where date(dateField) > date(date#('1-Jan-2016'))

Regards

[manojkulkarni]

something like

Load *

From test.csv

Where Date(DateField,'DD-MMM-YYYY') > '01-Jan-2016' ;

[tresesco]

I guess you meant import . If so, you can try like:

...

Where  Date(Date#(DateField, 'DD-MMM-YY') , 'DD-MMM-YYYY') > '1-Jan-2016' ;

[anuradhaa]

what happens if date is like 'Mar 27, 2015' and it's as general

[PrashantSangle]

Hi,

QlikView allowed you to format date as per requirement .

For above format you can try

Date(DateField,'MMM DD,YYYY')

For details you can read blog written by Henric.

The Date Function

Regards

[anuradhaa]

see attached csv.

Here i want to import data which has "Accepted at" in 2011.

Thanks

[sunny_talwar]

May be this:

SET DateFormat='D-MMM-YY';

Table:

LOAD Id,

    [Created at],

    [Accepted at]

FROM

testcsv.xlsx

(ooxml, embedded labels, table is Sheet1)

Where [Accepted at] > MakeDate(2011, 1, 1);

[jagan]

Hi,

If you just want data which is Accepted In 2011 then use

Data:

LOAD Id,

     Date([Created at], 'MM/DD/YYYY') AS [Created at],

     Date([Accepted at], 'MM/DD/YYYY') AS [Accepted at]

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE Year(Date([Accepted at], 'MM/DD/YYYY')) = 2011;

Hope this helps you.

Regards,

jagan.