topic Re: Pivot table Column placement in QlikView

Pivot table Column placement

Fri, 15 Jan 2016 17:44:32 GMT

I created a Pivot table with 6 columns A,B,C,D,E,F. It is grouped by column b,c,d and it has the column total of F based on the grouping. I was able to achieve it by Partial Sum on Column A. Now B,C,D columns are displayed and then column A is displayed. Is there any way I can make Column A as the first column along with grouping and total.

Also column F needs to move before column E. If I drag drop it it works in straight table and not in Pivot Table.

Can I achieve the same in Straight table.I want sub total of column F grouped by Column B,C,D. I can't do it in the LOAD as I am using the same columns differently across reports

Re: Pivot table Column placement

Fri, 15 Jan 2016 21:08:06 GMT

I am not fully understand your requirement. Can you please post sample qvw with data and what exactly do you need with output

Re: Pivot table Column placement

Fri, 15 Jan 2016 21:19:13 GMT

I understand that you have A,B,C,D,E in Dimensions and F as an Expression. You can promote the columns as per your requirement on the dimensions tab accordingly columns will be place as first, second and so on.

You can obtain subtotals on any of the dimensions column from the Presentation Tab by selecting Partial Sum. You can have subtotals for A, B, C, D dimension.

To move F before E, you have to put both F and E in Expression and then you can promote F before E in expressions tab.

Re: Pivot table Column placement

Fri, 15 Jan 2016 22:01:36 GMT

I am attaching the qvw and excel file I want Name as first column and Total to appear. This is GROUPEDBY first on PD, then ID, then CURR.. So total to appear based on these 3 columns. I did it in Pivot table, but if there is a way to do it in Straight table, I am fine with that also.

Re: Pivot table Column placement

Tue, 19 Jan 2016 13:42:29 GMT

With straight table you can get totals only on one level (i.e. for the expression).

You can group by PD, ID and CURR but Name cannot be the first column in that case. You can understand that Pivot table first column is the outermost column for the group by clause. Next column will give sub group of first column and so on. This is how subtotals work for pivot table.

Re: Pivot table Column placement

Tue, 19 Jan 2016 16:17:06 GMT

Yes Tripti, I understand. But the User needs this and I am trying to find out if there is any other way to do it. How about Dimensionality() , can that help. Thanks again

Re: Pivot table Column placement

Tue, 19 Jan 2016 17:26:23 GMT

Can you show in Excel what exactly you are looking for along with the total and sub- totals.

Re: Pivot table Column placement

Thu, 21 Jan 2016 21:51:51 GMT

Thanks for helping. I fixed the problem in script part. I avoided Pivot table and used straight table instead with scripting handling partial sums. Thanks @Tripti Gupta