topic Re: How i can get data for last 4 months & date is in MMM-YYYY format in QlikView

How i can get data for last 4 months & date is in MMM-YYYY format

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

Hi,

I have B.date in num format. I have take it as date(B.date) in script.

then take Date(MonthStart(B.date), 'MMM-YYYY'') as MonthYear fied.

Data is like :

B.date	Emp_Name	Salary
2018-02-02	A	100
2017-12-05	B	552
2017-08-05	C	555
2017-06-03	D	236

I have one pivot table in which dimension is Emp_Name and I want only last four month data of Salary as in expression sum(Salary)

How I Can write a expression?

Re: How i can get data for last 4 months & date is in MMM-YYYY format

sunny_talwar — Wed, 21 Mar 2018 12:53:57 GMT

May be this

Sum({<MonthYearField = {"$(='>=' & Date(MonthStart(Max(MonthYearField), -4), 'MMM-YYYY') & '<=' & Date(Max(MonthYearField), 'MMM-YYYY'))"}>}Salary)

Re: How i can get data for last 4 months & date is in MMM-YYYY format

sspawar88 — Wed, 21 Mar 2018 13:58:07 GMT

How can I do it at dimension rather than expression

Re: How i can get data for last 4 months & date is in MMM-YYYY format

sunny_talwar — Wed, 21 Mar 2018 14:02:31 GMT

May be this

If(MonthYearField >= MonthStart(Max(TOTAL MonthYearField), -4) and MonthYearField <= Max(TOTAL MonthYearField), MonthYearField)