Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
selimkocak
Contributor II
Contributor II

I can not top the total

Hello there,
I can not get the sum of the upper arm, as seen in the picture.
I will be glad if you help me.

IF(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )

+

SUM(TUTAR)

+

IF( (SUM(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0' )

Ekran Alıntısı.JPG

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum(Aggr(

If(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )

+

Sum(TUTAR)

+

If( (Sum(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0'), AP, HESAPAD, VADE))

If this doesn't work, then you will need to use Dimensionality() and/or secondaryDimensionality() functions to achieve your requirement

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

View solution in original post

2 Replies
sunny_talwar

Try this:

Sum(Aggr(

If(VADE>NOW()-1,Above(Sum(BORC),0,RowNo()) ,'0' )

+

Sum(TUTAR)

+

If( (Sum(BORC)>TOPLAMALACAK) , (Above(SUM(BORC),0,RowNo()) - TOPLAMALACAK) , '0'), AP, HESAPAD, VADE))

If this doesn't work, then you will need to use Dimensionality() and/or secondaryDimensionality() functions to achieve your requirement

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

selimkocak
Contributor II
Contributor II
Author

Thank you so much.