topic Re: Cell calculation in a table in QlikView https://community.qlik.com/t5/QlikView/Cell-calculation-in-a-table/m-p/513915#M554675 <HTML><HEAD></HEAD><BODY><P>Dave, I am unsure what your requirements are looking at your attached file.</P><P>Your data model contains no fact data, this might also support my confusion.</P><P></P><P>Can you post the excel file, too, so we can see what you are trying to achieve?</P><P></P><P>In general, you can't use a table box for calculations (i.e. using expressions). You'll need to use a chart (pivot, straight table, or one of the graphic charts).</P><P></P><P>You can then look into the inter chart record functions (above(), below(), before(),top() etc.), these might help you in doing what you want (well, I honestly don't know what you want, see above).</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 21 Aug 2013 15:05:07 GMT swuehl 2013-08-21T15:05:07Z Cell calculation in a table https://community.qlik.com/t5/QlikView/Cell-calculation-in-a-table/m-p/513914#M554674 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>could somebody take a short look at the attached file and tell me if it is possible to calculate each cell like i can do it in Excel?</P><P>My problem is that I can do it only per column and not for each cell. But i.e. for May I need # of logged and # of closed in one column...</P><P>I would be thankful for a short description!</P><P></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 21 Aug 2013 14:36:59 GMT https://community.qlik.com/t5/QlikView/Cell-calculation-in-a-table/m-p/513914#M554674 2013-08-21T14:36:59Z Re: Cell calculation in a table https://community.qlik.com/t5/QlikView/Cell-calculation-in-a-table/m-p/513915#M554675 <HTML><HEAD></HEAD><BODY><P>Dave, I am unsure what your requirements are looking at your attached file.</P><P>Your data model contains no fact data, this might also support my confusion.</P><P></P><P>Can you post the excel file, too, so we can see what you are trying to achieve?</P><P></P><P>In general, you can't use a table box for calculations (i.e. using expressions). You'll need to use a chart (pivot, straight table, or one of the graphic charts).</P><P></P><P>You can then look into the inter chart record functions (above(), below(), before(),top() etc.), these might help you in doing what you want (well, I honestly don't know what you want, see above).</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 21 Aug 2013 15:05:07 GMT https://community.qlik.com/t5/QlikView/Cell-calculation-in-a-table/m-p/513915#M554675 swuehl 2013-08-21T15:05:07Z