Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining Table

Hi,

I have a joining question.

I have a sales & purchases table.

Each jobID in Sales could have multiple purchases.

Some Purchase invoices wont have any JobID because they are like utilities bills.

I need to calculate the number of Invoices, sum of VAT and lots more.

If I use Join method then for an Invoice that has two purchases, it double counts the invoice number and double sums the VAT. If I use the Concatenate then it doesn't link everything properly.

I also need to combine both dates so that I can link it to one calendar.

What's the best method of doing this?

Any help will be appreciated.

Regards,

1 Reply
Not applicable

Hi Sarb,

please see attached, if you concatenate the two tables together and add a data type field to your final table, you can then use set analysis to count the correct type of data you want a total for. Still all via one date though

eg for Number of Invoices  Count({<Data_Type={'Invoice'}>} ID)

hope that helps

Joe