Formatting issue in Pivot table

[#1]

Dear friends,

I am working on a report with Pivot table chart. Please refer to the below screenshot of the current and expected report.

Below are the 3 issues which I am currently facing -

Issue 1 - I'm trying to move my dimension Label1 as the header of Label2. Please help that how can I achieve this.

Issue 2 - This report has input parameter of Year In the row and column totals, I want to append the header of Total values of the parameter, how to do it ??

Issue 3 - I dragged and dropped dimension quarter into Expression and now I want to hide this column Quarter, please suggest...

Warm regards,

Deepti

[Gysbert_Wassenaar]

1. That's not possible as far as I know. Qlikview is not a report generating tool for hardcopy output. So it doesn't have all sorts of page/section/table header and footer options to make sure things look pretty on paper.
   
   
2. Perhaps you can use the Indent option on the Style tab. Or you can try creating another dimension in the script:
   
   Labels:
   Load * inline [
   Label2-b, Label2
   A1, A1
   A2, A2
   ...etc
   A5, A5
   Total ABC, A1
   Total ABC, A2
   ...etc
   Total ABC, A5
   ];
   
   Then use then new field Label2-b instead of Label2
   
   
3. That can only be done with a macro: Hide column in pivot table

[#3]

Many thanks Gysbert for replying...

For Issue 1, can I achieve this formatting in Straight table??

For Issue 2, I could rename the Row Total as Year (2013) as the parameter will have one value at a time and I used expression

=Minstring(Year)

But can't use it for column total as Total ABC as =Minstring(Label1) otherwise it will show me the minimum value for all the dimensions.

Is there any possible way to use the current label in the total value

[Gysbert_Wassenaar]

For issue 1: I think it can be done in a straight table, but not very easily. See this blog post: How IntervalMatch Solved My Profit and Loss Dilemma

For issue 2: All the partial sum labels of a dimension will have the same text. You cannot get different partial sum labels for different dimension values. If you want custom totals you can try using the approach I outlined above, i.e. creating a new field in the script and use that as dimension instead of the original.