Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
crusader_
Partner - Specialist
Partner - Specialist

Nested Set Analisys Issue

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

5 Replies
crusader_
Partner - Specialist
Partner - Specialist
Author

Hi,

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

Please find attached a sample.

I need a fresh view.

Thanks.

Andrei

tresesco
MVP
MVP

Like this?

crusader_
Partner - Specialist
Partner - Specialist
Author

Almost

I got this result in text object.

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

I need get

AAA  |  800

Thanks

Not applicable

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_
Partner - Specialist
Partner - Specialist
Author

Thanks a lot!

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