topic Re: How to extract 2 days data from database in QlikView

How to extract 2 days data from database

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below requirement.

I have a table from SQL database

Here the DATE is in DD/MM/YYYY 00:00:00 format. so extracted date with DD/MM/YYYY using to_char function.

By using where condition I have to extract only 2 days data 02/04/2018 and 03/04/2018 and need to store in one qvd only. By defining static also fine.

i have used like this and extracted one day data using where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';

how to add 03/04/2018 here. Please help me on this

LOAD

DATE(DATE,'DD/MM/YYYY') as DATE,

TYPE,

STATUS,

SALES,

PRODUCT;

SELECT

to_Char(DATE,'DD/MM/YYYY') AS DATE,

TYPE,

STATUS,

SALES,

PRODUCT

FROM ....

where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';

Re: How to extract 2 days data from database

PrashantSangle — Fri, 06 Apr 2018 10:52:26 GMT

Use in() or between() in where clause

select * from tableName

where dateField in ('requiredDate','requiredDate')

select * from tableName

where dateField between 'FromDate' and 'toDate'

Regards,

Re: How to extract 2 days data from database

sudhirpkuwar — Fri, 06 Apr 2018 12:44:27 GMT

Hi,

Use where DATE >='02/02/2018' and <='03/02/2018'

Regards

Re: How to extract 2 days data from database

sasiparupudi1 — Fri, 06 Apr 2018 14:15:00 GMT

SELECT

to_Char(DATE,'DD/MM/YYYY') AS DATE,

TYPE,

STATUS,

SALES,

PRODUCT

FROM ....

where to_Char(DATE,'DD/MM/YYYY') Between '02/02/2018' AND '03/04/2018';

Re: How to extract 2 days data from database

sasiparupudi1 — Mon, 09 Apr 2018 15:05:14 GMT

have you got this working?

Re: How to extract 2 days data from database

Tanalex — Mon, 09 Apr 2018 15:16:54 GMT

SELECT

to_Char(DATE,'DD/MM/YYYY') AS DATE,

TYPE,

STATUS,

SALES,

PRODUCT

FROM ....

where to_Char(DATE,'DD/MM/YYYY') ='02/04/2018'

OR to_Char(DATE,'DD/MM/YYYY') ='03/04/2018';