topic Re: Re: Conditional Summation against a Date in QlikView

Conditional Summation against a Date

b_garside — Tue, 28 Jan 2014 19:20:21 GMT

I have a table were I want the summation to only work when a records Month is in range.

My example below I hope illustrates my goal.

The Closed date column should only show a value for Dec 2013 since the opportunity was closed that month.

But instead it shows the value for each month. The Active column is the inverse were it should show For Oct-Nov.

Active

Sum({<Status_CRM = {"1"} >}dol_PV_YR1)

Closed:

Sum( {< Stage = {'>=8<=11'} >} dol_PV_YR1)

proposed: lost on this?

If( CloseDate = Max(CloseDate) , Sum( {< Stage = {'>=8<=11'} ,Stage_Gate=,Status_CRM=,Status= >} dol_PV_YR1)/1000 )

Nicole-Smith — Tue, 28 Jan 2014 19:27:13 GMT

Please post a .qvw

Tue, 28 Jan 2014 19:34:39 GMT

upload QVW file

b_garside — Tue, 28 Jan 2014 20:09:43 GMT

Ok, I uploaded a QVW. Thanks

Nicole-Smith — Tue, 28 Jan 2014 20:19:55 GMT

Have a look at the file I have attached. It should give you what you need.

b_garside — Tue, 28 Jan 2014 20:31:52 GMT

Thanks Nicole! This is what I needed.