Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

Aggr with Above using if condition

Hello,
I'm in troubles with the below expression:

=sum(
aggr(
RangeSum(
above(
sum(
if(
Partite_CHIUSE.DataOperazione<%DataRegistrazione, 0, if( [Movimenti Scadenze.DataScadenzaSCA]<%DataRegistrazione, [Movimenti Scadenze.ImportoSCA], 0 ) )
)
, 0, RowNo(TOTAL) ) )
, %DataRegistrazione, %ChiaveScadenzaPagata )
)

in a straight table using %DataRegistrazione as dimension.

I need to compare the two fields Partite_CHIUSE.DataOperazione and [Movimenti Scadenze.DataScadenzaSCA] with %DataRegistrazione  of the current row  for all  above rows.

Is that possible?

Could anybody help me to achieve it? @sunny_talwar   @hic @stevedark @Gysbert_Wassenaar @rubenmarin1 @Thiago_Justen_ @Anil_Babu_Samineni @kaushiknsolanki @marcus_sommer @tresesco  

Many Thanks in advance for your time.

Best Regards and Take Care
Andrea

Labels (1)
10 Replies
Anil_Babu_Samineni

It's much clear now, Do you have any dashboard which demon the issue?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful