topic Last 3 months data in QlikView

Last 3 months data

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have 3 years of data with date field , but i need last 3 months of data Excluding current month.

for EX:- now April month is current month but i need "JAN,FEB,MARCH"

once if enter to "MAY" month i need "FEB,MARCH,APRIL" data.

Re: Last 3 months data

Chanty4u — Wed, 06 Apr 2016 04:44:44 GMT

chk dis

Re: How to Calculate the Last three Months Sales

Re: Last 3 months data

tamilarasu — Wed, 06 Apr 2016 04:50:53 GMT

Do you want set expression.? If so, try

Sum({$<Date={">=$(=MonthStart(AddMonths(Today(),-3)))<$(=MonthEnd(AddMonths(Today(),-1)))"}>} Sales)

Re: Last 3 months data

PrashantSangle — Wed, 06 Apr 2016 05:00:51 GMT

Hi,

create variable in script like

vLast3MonthStartDate=Monthstart(today(),-4);

vLastMonthEndDate=MonthEnd(Today(),-1);

while loading data use variable in where clause

Load *

from table

where Date>=$(vLast3MonthStartDate) and Date<=$(vLastMonthEndDate)

Regards

Re: Last 3 months data

HirisH_V7 — Wed, 06 Apr 2016 05:17:14 GMT

Hi,

Use this expression in your Table,

Sum({<Year=, Month =, Date={"$(='>=' & MonthStart(Today(), -2) & '<=' & MonthEnd(Today()))"}>} Sales)

HTH,

Hirish

Re: Last 3 months data

Wed, 06 Apr 2016 06:46:06 GMT

I will suggest dont use expression as its lower the performance.

I already face issue on same.

Go by dreamer4 way suggested.

Define variables and pass to scripts.

That will faster performance while you loading data.

This all when you have high amount of data.

Regards,

Lokesh

Re: Last 3 months data

SatyaPaleti — Wed, 06 Apr 2016 06:54:16 GMT

You have to create a Variable

vPreviousMonth =Monthstart(today(),-4);

vCurrentMonth =MonthEnd(Today(),-1);

Use the same Variable where you Required

Re: Last 3 months data

vishalmanu — Tue, 12 Sep 2017 06:23:10 GMT

This should work and probably a correct answer

Re: Last 3 months data

vinod22kv — Tue, 29 May 2018 08:33:29 GMT

Hi,

The bellow exprection is working fine for me.

=count({<Date = {'>$(=Max((Addmonths(Date,-3)))) <$(=Max (Addmonths(Date)))'}>} CallID)

Re: Last 3 months data

chetanpatel — Thu, 25 Feb 2021 02:31:13 GMT

if you want to select you can used below equation

='('& Date(monthname ( Today()),'MMM') & '|'& Date(monthname ( AddMonths(Today(),-1)),'MMM')& '|'& Date(monthname ( AddMonths(Today(),-2)),'MMM')& ')'