Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get sum of quantities for fields in one table that match with selected value of field in another table

Hello,

I have one table with Name, Quantity, and Data fields. Also, there are another table with Name field. I want to get sum of Quantities for fields where Name field in the first table matches with Name field in another table by date.

I tried Sum({<Name={$(vAntecendant)}, Date=>} Quantity), but it does not work. Here, vAntecedant is the selected Name value from the second table.


If I try Sum({<Description={"Product1"}, Date=>} Quantity) it works, but only for value "Product1". Also, when I create Text Box and display =$(vAntecendant it displays "Product1".


Could you help me to solve this problem?


1 Reply
sunny_talwar

May be try this

Sum({<Name={"$(=$(vAntecendant))"}, Date=>} Quantity)

or

Sum({<Name={"$(=vAntecendant)"}, Date=>} Quantity)