topic Re: trying to replicate chart in tablebox in QlikView https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000681#M966357 <HTML><HEAD></HEAD><BODY><P>Please close this thread by marking helpful and correct.</P><P></P><P>Thank You</P></BODY></HTML> Tue, 06 Oct 2015 02:32:12 GMT Anonymous 2015-10-06T02:32:12Z trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000675#M966351 <HTML><HEAD></HEAD><BODY><P>I have a chart which displays data based on the these conditions..</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">{ $&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[EVENT_GROUP]</SPAN><SPAN style="font-size: 8pt;"> = {HIRE}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">EMPLID</SPAN><SPAN style="font-size: 8pt;">)<BR /> +<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">{ $&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[BUS_PROCESS_TYPE]</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"HIRE"</SPAN><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">EMPLOYEE_ID</SPAN><SPAN style="font-size: 8pt;">)<BR /> </SPAN></P><P><SPAN style="font-size: 8pt;">how can I replace the same in table box or pivot..</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Year and Month are my dims..</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I was trying to write if in pivot or in table box but it is not quite simple..any help would be appreciated.</SPAN></P></BODY></HTML> Mon, 05 Oct 2015 20:13:07 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000675#M966351 2015-10-05T20:13:07Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000676#M966352 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101039_Capture.JPG" style="height: 228px; width: 620px;" /></P></BODY></HTML> Tue, 06 Oct 2015 01:48:15 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000676#M966352 settu_periasamy 2015-10-06T01:48:15Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000677#M966353 <HTML><HEAD></HEAD><BODY><P>Hi Venkat,</P><P></P><P>There is no concept of expression in Table box, so it is not possible in Tablebox, so you can try using Pivot/Straight tables.&nbsp; Add whatever dimensions you want in Straight /Pivot table and give this expression.&nbsp; This will works.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Oct 2015 02:04:55 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000677#M966353 jagan 2015-10-06T02:04:55Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000678#M966354 <HTML><HEAD></HEAD><BODY><P>Hi Venkat,</P><P></P><P>It won't work for Table Box. You try replicate with pivot table and add your expression.</P><P></P><P></P><P>Hope it helps!!</P></BODY></HTML> Tue, 06 Oct 2015 02:17:23 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000678#M966354 Anonymous 2015-10-06T02:17:23Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000679#M966355 <HTML><HEAD></HEAD><BODY><P>thanks everyone...I ran it thru with pivot table..:) </P></BODY></HTML> Tue, 06 Oct 2015 02:27:45 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000679#M966355 2015-10-06T02:27:45Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000680#M966356 <HTML><HEAD></HEAD><BODY><P>Make a copy of your chart and then switch the copy over to a Straight Table or Pivot Table in the General Tab of the chart properties by clicking the icon for Straight or Pivot. You don't need to replicate all the expressions since you can copy the entire chart and switch it to the right type...</P></BODY></HTML> Tue, 06 Oct 2015 02:29:56 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000680#M966356 petter 2015-10-06T02:29:56Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000681#M966357 <HTML><HEAD></HEAD><BODY><P>Please close this thread by marking helpful and correct.</P><P></P><P>Thank You</P></BODY></HTML> Tue, 06 Oct 2015 02:32:12 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000681#M966357 Anonymous 2015-10-06T02:32:12Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000682#M966359 <HTML><HEAD></HEAD><BODY><P>Hi Venkat,</P><P></P><P>Please close this thread by giving correct answer to the post which helps you in finding the answer.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 06 Oct 2015 03:20:02 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000682#M966359 jagan 2015-10-06T03:20:02Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000683#M966361 <HTML><HEAD></HEAD><BODY><P>Hi Venkat,</P><P></P><P>Please mark helpful and correct for appropriate and correct answers.</P><P></P><P></P><P>Thank You</P></BODY></HTML> Fri, 09 Oct 2015 14:30:40 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000683#M966361 Anonymous 2015-10-09T14:30:40Z Re: trying to replicate chart in tablebox https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000684#M966365 <HTML><HEAD></HEAD><BODY><P>Updated</P></BODY></HTML> Mon, 19 Oct 2015 14:39:53 GMT https://community.qlik.com/t5/QlikView/trying-to-replicate-chart-in-tablebox/m-p/1000684#M966365 2015-10-19T14:39:53Z