topic Re: Units not displaying properly in table box in QlikView

Units not displaying properly in table box

Mon, 13 May 2013 21:44:17 GMT

Hello,

I want to create a table box to accompany each chart I'm creating. Below is a screenshot of the issue I’m facing when trying to display units for each product segment by quarter. Instead of showing 12 quarters worth of unit results in the table box, I’m getting multiple results for each quarter and segment (see first table box). I’ve created a second table box to show you what I’m trying to achieve. Basically, I want the second table box to display the unit column with the results in the chart.

If anyone can assist in getting the units to display properly in the table box, I'd greatly appreciate it.

Regards,

Robert

Re: Units not displaying properly in table box

jpapador — Mon, 13 May 2013 21:52:56 GMT

You have to make a straight table instead of a regular table box use Quarter and Segment as your dimensions and them Sum(Units) as your expression. You could actually just copy your bar chart, then on the general tab (on the properties of the chart) change it from a bar chart to a straight table

Re: Units not displaying properly in table box

Mon, 13 May 2013 22:22:28 GMT

Hi,

Thanks for your quick reply. As you suggested, I copied my bar chart, then in the copied chart, I selected Properties and changed it from a bar chart to a straight table and it worked fine.

Regards,

Robert

Re: Units not displaying properly in table box

whiteline — Wed, 15 May 2013 06:58:12 GMT

Hi, Robert.

If the issue was solved, mark the jpapador's answer as correct to close the question, please.

Thanks.