topic Show Count of Invoices in QlikView

Show Count of Invoices

Thu, 03 Mar 2016 21:05:50 GMT

Hello!

I have a table that contains a list of backorders. Each of this has an associated Account Number, Product, and Invoice number. I have a second table that contains a history of posted invoices. I am trying to get a textbox to display the count of invoices for a specific customer based on the product that is currently on backorder for them.

Backorder:

Customer - A

Product - X

Invoice - 100

I want to find every invoice where A has purchased X. I attempted to use Set Analysis in several ways but I keep getting results that pertain to the selected Backorder alone.

I attached the table structure to assist in representing my model.

Re: Show Count of Invoices

settu_periasamy — Fri, 04 Mar 2016 03:36:34 GMT

If the fields are properly linked, try some think like

=Count({<Customer={'A'},Product={'X'}>}Invoice)

-> The above will give the result including duplicate value. If you don't want you can use 'Distinct'

-> Fields are case sensitive, give the exact Field you are using.

Re: Show Count of Invoices

Fri, 04 Mar 2016 19:58:35 GMT

Does this work if I need "A" and "X" to be derived from the selected record? For example, can I use the field name "Account" that corresponds to the field name "Customer" from a different table?