topic Working with wide tables ... Heeeelp! in QlikView https://community.qlik.com/t5/QlikView/Working-with-wide-tables-Heeeelp/m-p/706706#M540369 <HTML><HEAD></HEAD><BODY><P>We have a model wit Customers (about 4 million) and the scores of those customers.</P><P>About the Customers we have about 30 characteristics like Age, Region, Married, ...</P><P>For each cutomer we have 40 scores.</P><P></P><P>So first we made 2 tables of it:</P><P>* Customers with 4 million rows and 30 columns</P><P>* Scores with 160 million rows and 4 columns (Customer_ID, Score_Domain, Score_Name, Score)</P><P>But this model was very slow.</P><P></P><P>The next thing we did was adding the scores to the cusomer table.&nbsp; Each score was an extra column in the Customer table.</P><P>In this way we had 1 table with 4 Million customers and 70 columns.&nbsp; This was much faster but now we have lots of problems creating charts on scores.</P><P>For instance : How do we make (in this model) a chart with an overview of the scores for 1 specific domain for a certain group (eg all the male cust) of customers?</P><P>Uptil now the only possibility i see is making an expression for each socre, but this is a very time consuming an inflexible way to make charts...</P><P>Any other suggestions to handle these wide tables?</P></BODY></HTML> Mon, 04 Aug 2014 08:31:08 GMT 2014-08-04T08:31:08Z Working with wide tables ... Heeeelp! https://community.qlik.com/t5/QlikView/Working-with-wide-tables-Heeeelp/m-p/706706#M540369 <HTML><HEAD></HEAD><BODY><P>We have a model wit Customers (about 4 million) and the scores of those customers.</P><P>About the Customers we have about 30 characteristics like Age, Region, Married, ...</P><P>For each cutomer we have 40 scores.</P><P></P><P>So first we made 2 tables of it:</P><P>* Customers with 4 million rows and 30 columns</P><P>* Scores with 160 million rows and 4 columns (Customer_ID, Score_Domain, Score_Name, Score)</P><P>But this model was very slow.</P><P></P><P>The next thing we did was adding the scores to the cusomer table.&nbsp; Each score was an extra column in the Customer table.</P><P>In this way we had 1 table with 4 Million customers and 70 columns.&nbsp; This was much faster but now we have lots of problems creating charts on scores.</P><P>For instance : How do we make (in this model) a chart with an overview of the scores for 1 specific domain for a certain group (eg all the male cust) of customers?</P><P>Uptil now the only possibility i see is making an expression for each socre, but this is a very time consuming an inflexible way to make charts...</P><P>Any other suggestions to handle these wide tables?</P></BODY></HTML> Mon, 04 Aug 2014 08:31:08 GMT https://community.qlik.com/t5/QlikView/Working-with-wide-tables-Heeeelp/m-p/706706#M540369 2014-08-04T08:31:08Z