topic Re: set analysis Date in QlikView

set analysis Date

Thu, 13 Feb 2014 20:12:28 GMT

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

Re: set analysis Date

Thu, 13 Feb 2014 21:04:20 GMT

is it possible on Qlikview?

Re: set analysis Date

chiru_thota — Thu, 13 Feb 2014 22:39:08 GMT

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.

Re: set analysis Date

Fri, 14 Feb 2014 09:36:48 GMT

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