Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jeckstein
Contributor

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

Tags (2)
2 Replies
sinanozdemir
Valued Contributor III

Re: How to query across tables

Hi,

Try this:

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

or

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

Hope this helps.

jeckstein
Contributor

Re: How to query across tables

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

Community Browser