Verifying customer data?

[#1]

Hi,

New to the community so please forgive me if this question is too simple 😉

I've just started working with QlikView and am wondering something: How can you verify a resultset of data in the associative model contains all values and didn't loose some records along the way (for example because somewhere a leftjoin is needed)

Normally (in another tool) we would start developing with 1 or 2 tables, get the results, verify the results and build on. In QlikView you can start small but there's no way to track which rows possibly were lost when simple-joining everything together and therefore which actuals facts may not be correct?

Please help.

[#2 · Accepted solution]

Hi Karuna,

You dont loose any data in Qlikview due to the associative nature of model. In the GUI, if you pull fields from one table it will show you all it's records.

It's only when you start pulling fields from two or more tables (which are associated in your model), that you begin seeing data which logically comes from the association. In this case also you dont loose any record, the result is like full outer join.

You can verify the results in two ways - 1) Debug and see that expected number of records are loaded in a table, OR 2) Build a table box in GUI that has fields from tables you want to verify and see that you get expected records.

Thanks

Amit

[#3]

Amit,

Thanks for you reply. This mostly answers my question except I don't really get the 'full outer join' bit. Say I have two tables:

- one with Customer data

- one with Revenue per customer data

Lets say I load these tables separately via the script and they are associated on basis of their 'Customer_Id'. When I create a pivot showing me revenue per customer any customers that DONT have any revenue will be lost right?

So to find out which Customers were lost I have to use any of the two solutions you proposed?

If you can clear this up for that would be a big help.

Regards,

Albert "Karuna" Stevens

[#4]

Hi Karuna,

If a customers don't have any revenue, it will still appear in the chart. You can however hide such customers through chart properties (check "Suppress Zero-Values"). So you dont loose any data, it's just a matter of what you want to display or hide.

Thanks

Amit

[#5]

Amit,

thanks for sharing this info. Let's see if we can make this qvw work 🙂

Kind regards,

Karuna