topic Frequence tabulation in QlikView https://community.qlik.com/t5/QlikView/Frequence-tabulation/m-p/204670#M1209393 <HTML><HEAD></HEAD><BODY><P>For a unique transaction-number you should hardcode this in the script. Other calculations can be done in simple table/graphs, just with your required aggregation as Expression and required dimension. In the first approach think that this should do - you may then go lateron into more sophisticated formulas.</P><P>HTH<BR />Peter</P></BODY></HTML> Mon, 23 Nov 2009 17:50:34 GMT prieper 2009-11-23T17:50:34Z Frequence tabulation https://community.qlik.com/t5/QlikView/Frequence-tabulation/m-p/204669#M1209392 <HTML><HEAD></HEAD><BODY><P>I need you help for this.</P><P>I have a transaction table with4 columns</P><OL><LI>- Id client</LI><LI>- date of transaction</LI><LI>- product purchase</LI><LI>- Amount of product</LI></OL><P>From these datas , I would want to create a new summary table by Number of transaction</P><P>- Number of transaction (1 , 2 , 3 , ...) ; count of clients ; total amount</P><P>For example, I want to know, how many single client (who bougth one time), ...</P><P>I would want to know if I can build my table without using the script (with simple table) or i need to aggregate datas on the script ?</P><P>Thanks for your help</P><P>Jean-Jacques</P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 23 Nov 2009 17:45:41 GMT https://community.qlik.com/t5/QlikView/Frequence-tabulation/m-p/204669#M1209392 2009-11-23T17:45:41Z Frequence tabulation https://community.qlik.com/t5/QlikView/Frequence-tabulation/m-p/204670#M1209393 <HTML><HEAD></HEAD><BODY><P>For a unique transaction-number you should hardcode this in the script. Other calculations can be done in simple table/graphs, just with your required aggregation as Expression and required dimension. In the first approach think that this should do - you may then go lateron into more sophisticated formulas.</P><P>HTH<BR />Peter</P></BODY></HTML> Mon, 23 Nov 2009 17:50:34 GMT https://community.qlik.com/t5/QlikView/Frequence-tabulation/m-p/204670#M1209393 prieper 2009-11-23T17:50:34Z