topic normalize or not? in QlikView https://community.qlik.com/t5/QlikView/normalize-or-not/m-p/291767#M1202550 <HTML><HEAD></HEAD><BODY><P>The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.</P><P>-Rob</P></BODY></HTML> Wed, 01 Dec 2010 09:13:20 GMT rwunderlich 2010-12-01T09:13:20Z normalize or not? https://community.qlik.com/t5/QlikView/normalize-or-not/m-p/291766#M1202549 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have a excel file with a lot of sales data. Each row contains information of customer, date, referens and so on.</P><P>My question is if I should divide the table into several tables through the script so that I get a customer table, an order table, un order row table.</P><P>If I do it in SQL I would and then use JOIN</P></BODY></HTML> Wed, 01 Dec 2010 08:30:33 GMT https://community.qlik.com/t5/QlikView/normalize-or-not/m-p/291766#M1202549 2010-12-01T08:30:33Z normalize or not? https://community.qlik.com/t5/QlikView/normalize-or-not/m-p/291767#M1202550 <HTML><HEAD></HEAD><BODY><P>The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.</P><P>-Rob</P></BODY></HTML> Wed, 01 Dec 2010 09:13:20 GMT https://community.qlik.com/t5/QlikView/normalize-or-not/m-p/291767#M1202550 rwunderlich 2010-12-01T09:13:20Z