topic Re: Table help in QlikView

Table help

Thu, 05 May 2016 15:05:17 GMT

Hi guys! I need help creating a qlik table/chart. I'm currently getting this in my output:

But what I want to see is :

Is it possible to get this view in Qlik?

Re: Table help

Nicole-Smith — Thu, 05 May 2016 15:10:23 GMT

Use a pivot table and make sure pivoting is enabled (presentation tab). You should be able to drag your columns and rows to get the view that you want (and you'll need to add project as a dimension).

Re: Table help

Thu, 05 May 2016 15:13:59 GMT

I double checked that Pivoting is enabled but its not letting me drag the plan Year/Month to a row. Any suggestion?

Re: Table help

Thu, 05 May 2016 15:22:37 GMT

Update: Finally got it working. How can I tell the table to only display the value in this table if Qty>0?

Re: Table help

sunny_talwar — Thu, 05 May 2016 15:22:49 GMT

Yes, Pivot table is the way to go as Nicole‌ suggested. But how exactly will it work is difficult to suggest without looking at the data structure and the expressions. Would you be able to provide a sample?

Re: Table help

sunny_talwar — Thu, 05 May 2016 15:48:21 GMT

You can check the option to 'Suppress Zero Values' on the presentation tab

Re: Table help

Thu, 05 May 2016 20:46:44 GMT

Thank you for your response. I now have the pivot table layout fixed but it still is not Suppressing Zero Values even though the option has been selected. What could I be doing wrong?

Re: Table help

sunny_talwar — Thu, 05 May 2016 20:49:40 GMT

Would you be able to share a snapshot of what you are seeing?