topic Combined? in QlikView https://community.qlik.com/t5/QlikView/Combined/m-p/478005#M178521 <HTML><HEAD></HEAD><BODY><P>Attached file as below,</P><P></P><P>In the qlikview file, there is two table call desire table and Total Box.</P><P></P><P>I having problem putting a value on Total Box Dwell Days in Desire Table</P><P></P><P>I am able to achieve the value if I can create a table call Total Box,</P><P></P><P>The value for Over Type,Month 10, will be (3*2) + (6*4) = 30,</P><P>Value fo Important Type, Month 10, will be (4*1) + (8*5) = 44</P><P></P><P>Thus, the value of 30 and 44 should be in Desire table,</P><P></P><P>Thanks very much!</P><P></P><P>I believe is aggr but I have no clue on how to do it</P></BODY></HTML> Sun, 14 Jul 2013 15:38:17 GMT n1ef5ng1 2013-07-14T15:38:17Z Combined? https://community.qlik.com/t5/QlikView/Combined/m-p/478005#M178521 <HTML><HEAD></HEAD><BODY><P>Attached file as below,</P><P></P><P>In the qlikview file, there is two table call desire table and Total Box.</P><P></P><P>I having problem putting a value on Total Box Dwell Days in Desire Table</P><P></P><P>I am able to achieve the value if I can create a table call Total Box,</P><P></P><P>The value for Over Type,Month 10, will be (3*2) + (6*4) = 30,</P><P>Value fo Important Type, Month 10, will be (4*1) + (8*5) = 44</P><P></P><P>Thus, the value of 30 and 44 should be in Desire table,</P><P></P><P>Thanks very much!</P><P></P><P>I believe is aggr but I have no clue on how to do it</P></BODY></HTML> Sun, 14 Jul 2013 15:38:17 GMT https://community.qlik.com/t5/QlikView/Combined/m-p/478005#M178521 n1ef5ng1 2013-07-14T15:38:17Z Re: Combined? https://community.qlik.com/t5/QlikView/Combined/m-p/478006#M178522 <HTML><HEAD></HEAD><BODY><P>This is a duplicate post, isn't it? Try avoiding this, it makes it hard to follow a discussion.</P><P></P><P>=sum(aggr(Days*sum(Box), Month,Type,Days))</P></BODY></HTML> Sun, 14 Jul 2013 15:40:25 GMT https://community.qlik.com/t5/QlikView/Combined/m-p/478006#M178522 swuehl 2013-07-14T15:40:25Z