topic Re: How to sum values past in QlikView

How to sum values past

Thu, 30 Jan 2014 18:41:45 GMT

Hello.

I was wondering, whats the proper format of the expressión, in order to Sum only the values previuos from today.

for Example, i got all the planned values of the year. How can i only sum those that are previuos from today?

Any ideas?

Do i make myself clear?

thanks,

Thu, 30 Jan 2014 19:09:32 GMT

Hi,

Assuming you have 1 straight table with DateField and PlannedValue (and eventually other fields): some possibilities

Sum(if(DateField<Today(), PlannedValue))

-Sum((DateField<Today())*PlannedValue)

There are several other ways. If it doesn't work, please post some sample data.

Hope this helps.

maxgro — Thu, 30 Jan 2014 19:17:59 GMT

or with set analysis

sum({$ <Date={"<$(=floor(Today()))"}>} PlannedValue )

ashwanin — Thu, 30 Jan 2014 19:21:20 GMT

sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Values)