Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
simonecimino
Contributor II
Contributor II

Add specific values in the table

Good morning,
do you know how to add the values of the "Importo incasso" column for each "IDENTIFICATIVO BONIFICO"?

So if I have 3 lines with the same "IDENTIFICATIVO BONIFICO" I would like to display the total sum of "Importo Incasso" for that "IDENTIFICATIVO BONIFICO"


Cattura.PNG

8 Replies
Taoufiq_Zarra

@simonecimino  if i understood correctly

sum(total <[IDENTIFICATIVO BONIFICO]> [Importo Incasso])

if not can you share a sample data and the expected output in table format

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
simonecimino
Contributor II
Contributor II
Author

Thanks for the reply  @Taoufiq_Zarra 1.PNG

I tried what you suggested. However, I expect to find the total sum for each line, so 115.24 repeated on the 3 lines that have that "IDENTIFICATIVO BONIFICO"

Taoufiq_Zarra

can you attached a sample data and the expected output? @simonecimino 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
simonecimino
Contributor II
Contributor II
Author

I would like to get the column highlighted in red. @Taoufiq_Zarra 

1.PNG

Taoufiq_Zarra

@simonecimino 

Dimension: Importo Incasso and IDENTICATIVO BONIFICO

and measure : 

sum(total <[IDENTICATIVO BONIFICO]> [Importo Incasso])

 

output:

Taoufiq_Zarra_0-1623315059651.png

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
simonecimino
Contributor II
Contributor II
Author

@Taoufiq_Zarra Unfortunately I don't get the same output ... I probably have some problems in the inputs ...

I get "IDENTIFICATIVO BONIFICO" like this

=If(WildMatch([CSVexport (1).Descrizione],'*'&Fatture&'*'), TextBetween([CSVexport (1).Descrizione], 'Cro: ', ' Note:'))


 

and I get "IMPORTO INCASSO" like this

= If(WildMatch([Fatture],'*'&S_FATTURA_DEF&'*'), TOTALE_IMPORTO)

 

 

Taoufiq_Zarra

@simonecimino  that's why I ask for the initial input

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
simonecimino
Contributor II
Contributor II
Author

@Taoufiq_Zarra Sorry, I don't understand. In input I have two separate excel files and I get "IDENTIFICATIVO BONIFICO" and "IMPORTO INCASSO" as I explained above.