topic Re: Formatting issue in Pivot table in QlikView

Formatting issue in Pivot table

Wed, 22 Oct 2014 05:49:57 GMT

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

Re: Formatting issue in Pivot table

Gysbert_Wassenaar — Wed, 22 Oct 2014 06:13:30 GMT

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.
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
That can only be done with a macro: Hide column in pivot table

Re: Formatting issue in Pivot table

Wed, 22 Oct 2014 06:35:37 GMT

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

Re: Formatting issue in Pivot table

Gysbert_Wassenaar — Wed, 22 Oct 2014 08:03:41 GMT

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.