topic Re: Data modeling in QlikView

Data modeling

souadouert — Mon, 13 Mar 2017 08:13:57 GMT

good morning

I have several qvd files(20) that designate a product for exemple(Insurance, credit, convention), the files have some columns with the same name but not the same values. So I opted to group products by category, is what you choose to group all the files in a same table or each category in a table.

I am looking for the most logical and optimal solution in terms of perfermoonce

Re: Data modeling

ahaahaaha — Mon, 13 Mar 2017 08:41:05 GMT

Hi,

In principle, you can download all the files to one by adding an additional field "Category".

Regards,

Andrey

Re: Data modeling

souadouert — Mon, 13 Mar 2017 08:51:17 GMT

Yes, I have already coded this solution, but I'm doing my internship at the end of the study so i have to have a design that meets the standards of business intelligence

Re: Data modeling

ahaahaaha — Mon, 13 Mar 2017 09:08:17 GMT

The pivot table variant will not suit?

Re: Data modeling

souadouert — Mon, 13 Mar 2017 09:49:40 GMT

I'm talking about modeling data and not the reporting phase

Re: Data modeling

migueldelval — Mon, 13 Mar 2017 09:57:08 GMT

Hi Souad,

I think that you don´t need to agrupate all your info in a table, because performance are going to be worst.

It´s better to use Qualify/UnQualify and make a link table with the category.

Performance and Optimization Best Practices in QlikView & Qlik Sense

Re: Data modeling

souadouert — Mon, 13 Mar 2017 10:00:53 GMT

Good morning Miguel

I agree with you, for that I am looking for a solution that respects best practices