topic Re: Pivot Table Grouping in QlikView

Pivot Table Grouping

Mon, 09 May 2016 08:51:39 GMT

Guys I'm stuck at making a pivot table. Below is the screen cap of it.

I'm trying to show server inventory, and you can see last 2 columns are duplicated after memory columns. Is there a way I can only show those 4 disk drive utilization columns only once for each server? I really couldn't find a way to do it.

Thank you very much for your help.

Re: Pivot Table Grouping

settu_periasamy — Tue, 10 May 2016 05:28:07 GMT

Have you tried to interchange your last two columns and check?

Re: Pivot Table Grouping

avinashelite — Tue, 10 May 2016 06:08:49 GMT

change the column ordering of the Server and disk drive that should solve the issue

Re: Pivot Table Grouping

Tue, 10 May 2016 06:13:33 GMT

Hi settu_periasamy,

Thanks for your reply. I tried and it won't help. It seems to me that in a pivot table, once it's split into 2 rows for one single record, all data belonging to that record afterward will be represented in at least 2 sets. In this example, disk utilization data is duplicated from memory utilization.

Re: Pivot Table Grouping

Tue, 10 May 2016 06:18:26 GMT

Hi Avinash, thanks for your reply!

However, seems like it won't work. In fact I did try changing the order of my data, but It seems to me that in a pivot table, once it's split into 2 rows for one single record, all data belonging to that record afterward will be represented in at least 2 sets.

Here is actually the full capture of my table in which I followed your suggestion. Am I still doing anything wrong?