topic Re: Nested Set Analisys Issue in QlikView

Nested Set Analisys Issue

crusader_ — Fri, 01 Aug 2014 14:40:16 GMT

Hello Community,

How to find Amount where

Tran_date=min(Tran_date) from set where Tran_date={">=$(=num(TRIALPERIOD))"}

using Set Analisys only.

I need to find first transaction after expiring Trial Period.

Thanks in advance.

Andrei

crusader_ — Tue, 05 Aug 2014 07:51:07 GMT

Hi,

I almost find the solution, but faced on some difficulties.

Please find attached a sample.

I need a fresh view.

Thanks.

Andrei

tresB — Tue, 05 Aug 2014 07:55:43 GMT

Like this?

crusader_ — Tue, 05 Aug 2014 08:08:55 GMT

Almost

I got this result in text object.

I need Sum( TRN) where STARTDATE=(min(STARTDATE which >=TRIALPERIOD))

I need get

AAA | 800

Thanks

Tue, 05 Aug 2014 08:18:05 GMT

Hello Andrei,

Please use below as expressions:

=sum({$<STARTDATE = {"$(=date(min({$<STARTDATE={'>=$(=num(TRIALPERIOD))'}>} STARTDATE)))"} >} TRN)

Also find PFA. Hope it was helpful

Thanks,

Angad

crusader_ — Tue, 05 Aug 2014 08:23:41 GMT

Thanks a lot!

I supposed that the problem was in quotes, but couldn't find how to deal with them.