topic Re: Set Analysis Last 5 sales in QlikView

Set Analysis Last 5 sales

Tue, 11 Sep 2012 12:51:55 GMT

Good day. I need to calculate the sum of the last 5 sales when sales were greater than 0

for example should get 19

sivarajs — Tue, 11 Sep 2012 13:04:17 GMT

Use expressions as

sum ({<"Date" ={">$(=max(Date)-5)<=$(=max(Date))"}>}Count)

--Siva

Tue, 11 Sep 2012 13:08:58 GMT

I need to pass the date in which the sale was 0

With your expression result is 9, and I need to get 16

sivarajs — Tue, 11 Sep 2012 13:14:17 GMT

How you are saying 16 can you explain little?

Tue, 11 Sep 2012 13:19:11 GMT

sorry, could not correctly written

Tue, 11 Sep 2012 13:22:08 GMT

corrected first post

For example: From the last date five sales should get 19

sivarajs — Wed, 12 Sep 2012 05:18:22 GMT

This might helps you

sum

({<"Date" ={">=$(=max(Date)-5)<=$(=max(Date))"},Count={">0"}>}Count)

Wed, 12 Sep 2012 06:50:46 GMT

Thanks for the answer, but it is wrong, turn 16, and 19 should

And for example, dates can not go in sequence, ie,

Date Count

05.12.2010 2

08.12.2010 2

15.12.2010 1

01.01.2011 1

05.01.2011 2

You should now have 8, and in your terms, it considers the last two dates and issue 3

whiteline — Wed, 12 Sep 2012 06:55:57 GMT

This works fine, even with user selections:

=Sum({<Date={">=$(=FirstSortedValue({<Count={'>0'}>} total Date, -Date, 5))"}>} Count)

Wed, 12 Sep 2012 07:01:58 GMT

Thanks for the answer, it's something that we should