topic Re: Data Modeling in QlikView

Data Modeling

Wed, 25 Nov 2020 16:16:04 GMT

I have Store And Sales tables

Store	Area
A	100
B	200

Store	Product	Price	Date
A	1	1.25$	18/01/2016
A	2	2.25$	19/01/2016
A	3	3.25$	18/01/2016
B	1	1.25$	19/01/2016
B	2	2.25$	20/01/2016

Select * from Store, Sales where Store.Store= Sales.Store will Return

Area	Store	Product	Price	Date
100	A	1	1.25	18/01/2016
100	A	2	2.25	19/01/2016
100	A	3	3.25	18/01/2016
200	B	1	1.25	19/01/2016
200	B	2	2.25	20/01/2016

The Sum(Area) =700. How can i get Accurate Sum of Area in Qlikview?

How do we resolve this issue in Qlikview?

Re: Data Modeling

sunny_talwar — Sun, 09 Apr 2017 13:50:50 GMT

So intead of joining these two tables, you can keep them as separate tables, but connected on Store... Once you do that your Sum(Area) will give you 300 and there will be still an association between the two tables through Store field.

Re: Data Modeling

Anonymous — Sun, 09 Apr 2017 13:51:47 GMT

Srikanth,

You should normalize your table in this scenario. Maintain data in separate tables.

Re: Data Modeling

Or — Sun, 09 Apr 2017 13:52:18 GMT

You've forgotten to tell us what the expected result is..

As long as you bring each table into your QlikView model individually - that is, select * from Store and select * from Sales (they will auto-join on Store because it is the same name in both tables), you should get 300 for sum(area). If you actually want 700, you need to pre-join the tables in your SQL, as you have in your example.

Re: Data Modeling

sureshsindhigi — Sun, 09 Apr 2017 17:50:42 GMT

Hi Srikanth,

As sunny Talwar mentioned, use the attached QVW file for the reference, Hope it will provide the solution which is looking for you.

Regards,

Suresh Sindhigi.