set analysis Date

[#1]

Hi All,

I have an application with:

- orderID

- orderStatus (integer value)

- orderDate

- orderAmount

- ComparaisonDate (field not linked to the data model)

I need to calculate the sum of orderAmount where orderStatus has increased between a selected max(ComparaisonDate) and max(orderDate), and orderStatus is not null on both periods.

Regards,

Yacine

[#2]

is it possible on Qlikview?

[chiru_thota]

Hi,

It may be possible.you can try below approach.

You need to introduce one more new Counter column in for each OrderID to identify status increased or not when compared to previous date.This can be added in QV data model it self.

So that you can use that column in set analysis while calculating orderAmount

Thanks,

Chiru.

[#4]

Hi,

I started an expression but I think that I have a mistake somewhere. can you help to correct it pls:

=sum({<Date={"$(=date(max([CalendarComparison.Year Month])))"}, [orderStatus]={"=$(=only({1<Date={'$(=date(max([Year Month])))'}>} [orderStatus ]))"}>} [orderAmount])

Rgds