topic Re: tablebox in QlikView https://community.qlik.com/t5/QlikView/tablebox/m-p/760838#M270691 <HTML><HEAD></HEAD><BODY><P>Load name ,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sal,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bonus,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; advance,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sal+bonus-advance as [total sal]</P><P>Form yoursource;</P><P></P><P></P><TABLE style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">e</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 24 Jan 2015 20:21:17 GMT MarcoWedel 2015-01-24T20:21:17Z tablebox https://community.qlik.com/t5/QlikView/tablebox/m-p/760835#M270688 <HTML><HEAD></HEAD><BODY><TABLE><TBODY><TR><TD>name</TD><TD>id</TD><TD>sal</TD><TD>bonuas</TD><TD>addvance</TD></TR><TR><TD>aaaa</TD><TD>1</TD><TD>12345</TD><TD>1222</TD><TD>111</TD></TR><TR><TD>bbbb</TD><TD>2</TD><TD>3223</TD><TD>5433</TD><TD>122334</TD></TR><TR><TD>cccc</TD><TD>3</TD><TD>3211</TD><TD>45567</TD><TD>122334</TD></TR><TR><TD>dddd</TD><TD>4</TD><TD>56788</TD><TD>556</TD><TD>456677</TD></TR><TR><TD>eeee</TD><TD>5</TD><TD>33334</TD><TD>4322</TD><TD>56788</TD></TR><TR><TD>ffff</TD><TD>6</TD><TD>54322</TD><TD>33445</TD><TD>23345</TD></TR><TR><TD>gggg</TD><TD>7</TD><TD>7654</TD><TD>3333</TD><TD>65433</TD></TR><TR><TD>kkkkk</TD><TD>8</TD><TD>322111</TD><TD>3345</TD><TD>223345</TD></TR><TR><TD>llllll</TD><TD>9</TD><TD>5432</TD><TD>12345</TD><TD>43332</TD></TR><TR><TD>nnnn</TD><TD>10</TD><TD>5682</TD><TD>7823</TD><TD>9783<TABLE><TBODY><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P>i have load this table from exel </P><P>then i want another column which is Total sal. in this Total sal values shouid be ((sal+bonus)-advance)</P><TABLE height="274" style="width: 380px; height: 242px;"><TBODY><TR><TD>name</TD><TD>id</TD><TD>sal</TD><TD>bonuas</TD><TD>addvance</TD><TD>Total sal</TD></TR><TR><TD>aaaa</TD><TD>1</TD><TD>12345</TD><TD>1222</TD><TD>111</TD><TD>sal+bonus-addvance</TD></TR><TR><TD>bbbb</TD><TD>2</TD><TD>3223</TD><TD>5433</TD><TD>122334</TD><TD></TD></TR><TR><TD>cccc</TD><TD>3</TD><TD>3211</TD><TD>45567</TD><TD>122334</TD><TD></TD></TR><TR><TD>dddd</TD><TD>4</TD><TD>56788</TD><TD>556</TD><TD>456677</TD><TD></TD></TR><TR><TD>eeee</TD><TD>5</TD><TD>33334</TD><TD>4322</TD><TD>56788</TD><TD></TD></TR><TR><TD>ffff</TD><TD>6</TD><TD>54322</TD><TD>33445</TD><TD>23345</TD><TD></TD></TR><TR><TD>gggg</TD><TD>7</TD><TD>7654</TD><TD>3333</TD><TD>65433</TD><TD></TD></TR><TR><TD>kkkkk</TD><TD>8</TD><TD>322111</TD><TD>3345</TD><TD>223345</TD><TD></TD></TR><TR><TD>llllll</TD><TD>9</TD><TD>5432</TD><TD>12345</TD><TD>43332</TD><TD></TD></TR><TR><TD>nnnn</TD><TD>10</TD><TD>5682</TD><TD>7823</TD><TD>9783</TD><TD></TD></TR></TBODY></TABLE><P>like this how i can get. where i should write the expression</P></BODY></HTML> Sat, 24 Jan 2015 17:43:46 GMT https://community.qlik.com/t5/QlikView/tablebox/m-p/760835#M270688 2015-01-24T17:43:46Z Re: tablebox https://community.qlik.com/t5/QlikView/tablebox/m-p/760836#M270689 <HTML><HEAD></HEAD><BODY><P>Use an object graph straight table</P><P>1) Add dimension <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">name</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">2) Add Dimension id</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">3) Add expression sum(sal)</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">4) Add expression sum(bonuas)</SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">5) Add expression sum(addvance)<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">6) Add expression rangesum(sal,bonuas,-addvance)<BR /></SPAN></P></BODY></HTML> Sat, 24 Jan 2015 17:50:48 GMT https://community.qlik.com/t5/QlikView/tablebox/m-p/760836#M270689 Clever_Anjos 2015-01-24T17:50:48Z Re: tablebox https://community.qlik.com/t5/QlikView/tablebox/m-p/760837#M270690 <HTML><HEAD></HEAD><BODY><P>see attachment (in a chart, not in tablebox)</P></BODY></HTML> Sat, 24 Jan 2015 18:10:11 GMT https://community.qlik.com/t5/QlikView/tablebox/m-p/760837#M270690 maxgro 2015-01-24T18:10:11Z Re: tablebox https://community.qlik.com/t5/QlikView/tablebox/m-p/760838#M270691 <HTML><HEAD></HEAD><BODY><P>Load name ,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sal,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bonus,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; advance,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sal+bonus-advance as [total sal]</P><P>Form yoursource;</P><P></P><P></P><TABLE style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">e</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 24 Jan 2015 20:21:17 GMT https://community.qlik.com/t5/QlikView/tablebox/m-p/760838#M270691 MarcoWedel 2015-01-24T20:21:17Z