topic Re: Total in straight table in QlikView https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491759#M482396 <HTML><HEAD></HEAD><BODY><P>Please, paste the expression you used. An if condition may cause problems in the total, as qlikview might find impossible to aggregate the condition used. Is it impossible to replace the if with a set analysis?</P></BODY></HTML> Wed, 14 Aug 2013 06:18:23 GMT 2013-08-14T06:18:23Z Total in straight table https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491758#M482395 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>Please refer attachment of&nbsp; h1.jpg&nbsp; in this I have created straight table base on conditions&nbsp; high value and high growth , </P><P>quadrant wise report base on conditions if ( ) used in expression but total is not appering in straight table.</P><P></P><P>any one have idea how to arrive the total.</P><P></P><P></P><P>Regards</P><P></P><P>Vikas</P></BODY></HTML> Wed, 14 Aug 2013 05:50:16 GMT https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491758#M482395 vikasmahajan 2013-08-14T05:50:16Z Re: Total in straight table https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491759#M482396 <HTML><HEAD></HEAD><BODY><P>Please, paste the expression you used. An if condition may cause problems in the total, as qlikview might find impossible to aggregate the condition used. Is it impossible to replace the if with a set analysis?</P></BODY></HTML> Wed, 14 Aug 2013 06:18:23 GMT https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491759#M482396 2013-08-14T06:18:23Z Re: Total in straight table https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491760#M482397 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Your attachment is missed from your post. If possible, please attach your application aswell. </P></BODY></HTML> Wed, 14 Aug 2013 06:43:39 GMT https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491760#M482397 2013-08-14T06:43:39Z Re: Total in straight table https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491761#M482398 <HTML><HEAD></HEAD><BODY><P>Give a try:</P><P></P><P>Change the 'Total Mode' (under expression tab) to 'Sum of rows'</P><P></P><P>Note: this depends on your expression and requirement</P></BODY></HTML> Wed, 14 Aug 2013 06:58:05 GMT https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491761#M482398 tresB 2013-08-14T06:58:05Z Re: Total in straight table https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491762#M482399 <HTML><HEAD></HEAD><BODY><P>in dimension limit tab for that check on Show total </P><P>hope it helps</P></BODY></HTML> Wed, 14 Aug 2013 07:28:23 GMT https://community.qlik.com/t5/QlikView/Total-in-straight-table/m-p/491762#M482399 er_mohit 2013-08-14T07:28:23Z