topic Re: How to restrict only Last 2 days data in QlikView

How to restrict only Last 2 days data

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

Hi Experts,

Can any one please help me to restrict only last 2days data in the below extraction.

Load

DepartmentName,

Departmentid,

Date,

Salary

From ....

Here Date is in DD/MM/YYYY hh:mm:ss format. Requirement is Need to extract only Today and previous date data into qvd i.e., need to restrict only last 2days.

Please help me on this.

Thanks in advance.

Re: How to restrict only Last 2 days data

chinnuchinni — Thu, 19 Apr 2018 04:34:35 GMT

Load

DepartmentName,

Departmentid,

Date,

Salary

From ....

Where Date(Date,'MM/DD/YYYY')>=date(Today()-1,'MM/DD/YYYY')

Re: How to restrict only Last 2 days data

keerthika — Thu, 19 Apr 2018 05:50:19 GMT

Hi,

You can try like this

Load

DepartmentName,

Departmentid,

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

Salary

From ...

where Date<=date#(date(today()),'MM/DD/YYYY') and Date>=date#(date(today()-1),'MM/DD/YYYY');

Re: How to restrict only Last 2 days data

vishalarote — Thu, 19 Apr 2018 06:20:34 GMT

Try this Hope so it will help you.

E.g.

load

Date(MakeDate(2018)+RecNo()-1,'DD/MM/YYYY') as Date,

rand()*1000 as Sales

AutoGenerate 365;

STORE X into 'C:\Project\MyTable6.qvd'(qvd);

DROP Table X;

load *

From 'C:\Project\MyTable6.qvd'(qvd)

where Date>=Today()-1 and Date<=Today();