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: 
jeckstein
Partner - Creator
Partner - Creator

How to query across tables

I am looking to find the sum(ProducePrice) for all the orders.

I have orders and Product information set up into two tables. and they are linked.

How would I create a text box to show the total sum(ProductPrice) of every order.

Screenshot qliksense.PNG

2 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

Try this:

Sum({<OrderID={"*"}>}ProducePrice)

or

Sum({<OrderID={"=Lem(Trim(OrderID))>0"}>}ProducePrice)

Hope this helps.

jeckstein
Partner - Creator
Partner - Creator
Author

I ended up using a Mapping Load/ Apply Map to solve this problem.