topic Re: i need previous 3 months data..(set analysis) in QlikView

i need previous 3 months data..(set analysis)

Mon, 29 Apr 2013 12:20:14 GMT

Hi community,

I have a problem that is, when ever i select Year and Month then i need previous 3 months data.

Example:

year :2012

Month : Sep

Now i need sum of previous 3 months : Aug+July+Jun .

Thanks ,

satti

sushil353 — Mon, 29 Apr 2013 12:37:40 GMT

Hi,

Please find the attached app.

Hope that helps you.

Sushil

kaushiknsolanki — Mon, 29 Apr 2013 12:58:40 GMT

Hi,

Use the expression like shown below.

sum({<Date = {">=$(=Addmonths(makedate(max(Year),Max(Month)),-3))"},Year=,Month=>}Sales)

Regards,

Kaushik Solanki

Tue, 30 Apr 2013 07:47:33 GMT

Hi Kaushik Solanki,

I have used sushil kumar's attached Application to check our Expression. but i did not get expected result.

Could you plz check expression with attached Application.

Thanks and Regards,

Satti

jagan — Tue, 30 Apr 2013 08:11:43 GMT

Hi,

Try like this

sum({<DateFieldName = {">=$(=MonthStart(Max(DateFieldName), -3))<=$(=MonthEnd(Max(DateFieldName), -1))"},Year=,Month=, Quarter=>}Sales)

Hope this helps you.

Regards,

Jagan.

Tue, 30 Apr 2013 12:53:09 GMT

thanks Jagan

It's working .