topic Re: How to get Last 6 months Data in QlikView

How to get Last 6 months Data

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

Hi,

Can Some one help me how to filter Last 6 months data from current Date in Qlikview Load Script.

Example

Today Date is 5\15\2017 so it should go last 6 months date 11\15\2016. so results should give me from 11\15\2016 to till date.

How can i give in Qlikview load script of where condition.

Best Regards,

Re: How to get Last 6 months Data

MindaugasBacius — Mon, 15 May 2017 11:44:39 GMT

This might help:

Load *

From

Where Date >= AddMonth(Today(), -6)

;

Re: How to get Last 6 months Data

Anonymous — Mon, 15 May 2017 11:47:49 GMT

sum({<[Ship Date]={'>=$(=addmonths(today(),-6))<=$(=today())'}>}Sales) ---Set analysis

let vfirstdate= today()

let venddate= addmonth(today(),-6)

calendar:

load date(vfisrtdate+iterno()-1) as Date

autogenerate 1

while $(venddate)<=$(vfirstdate);

add this to calendar

Re: How to get Last 6 months Data

qlikview979 — Mon, 15 May 2017 11:49:31 GMT

may be this is help full to you

Rolling Month

Re: How to get Last 6 months Data

vinieme12 — Mon, 15 May 2017 11:49:38 GMT

Read this post

Dates in Set Analysis

vLastMonth= "=Date(Max(Month),'MMM-YY')";

v2ndLastMonth= "=Date(AddMonths(Max(Month),-1),'MMM-YY')";

vLast6Month= =Date(AddMonths(Max(Month),-5),'MMM-YY')

Re: How to get Last 6 months Data

sanjay006 — Mon, 15 May 2017 11:50:30 GMT

Hi HariKiran !

Use this:

Load *

From XYZ

Where Date >= AddMonth(Today(), -6);

Re: How to get Last 6 months Data

MindaugasBacius — Mon, 15 May 2017 11:52:22 GMT

In case you are willing to have a flag only. In the Calendar table add this:

Calendar:

Load *

,If(Date >= AddMonth(Today(), -6), 1, 0) as 6LastMonths

From

;

Re: How to get Last 6 months Data

dunnalahk123 — Thu, 18 May 2017 12:10:20 GMT

Hi Bacius,

Thank You that Helps For now. 🙂

Sorry for delay in Responding.

Best Regards,

Hari

Re: How to get Last 6 months Data

sanjay006 — Thu, 18 May 2017 12:22:04 GMT

Plz find the attached file.You can change the expression as for your requirement.

For now m showing it for previous 6 months data.