topic Re: Pivot table alignment issue in QlikView

Pivot table alignment issue

bushpalaamarnat — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Could any one please help, it is urgent requirement.

I have attached an excel file with the pivot out put showing as current Format. and can we do the new output format in the pivot or any other chart of the qlikview.

Re: Pivot table alignment issue

jubarrosor — Wed, 18 Apr 2018 10:40:18 GMT

Hi Neelima:

You must add the values:

%Limits Not-Set

%Limits Incorrect

as dimension and use two expresion (i.e. with if) depend on the dimension value.

Best Regards,

Juan P. Barroso

Re: Pivot table alignment issue

Anonymous — Wed, 18 Apr 2018 11:13:31 GMT

Hi,

Create a normal pivot table with the two dimensions. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

Hope that helps

Re: Pivot table alignment issue

bushpalaamarnat — Wed, 02 May 2018 04:29:50 GMT

Hi,

Thank you for your response, I believe you are correct. I need little more help.

Could you please help how to do this? am lost in my tool.

how to do this? do I have amend the back end?

=if([Week Representation]='Current',[Corridor Status])	Set	Not Set	Invalid
Total	19912	361	7122
Valid	10130	0	0
% Valid	0.508738449	0	0
Ramp-Down	370	0	18
%Ramp-Down	3%	0%	0%
Limits Not-Set	2,696	340	0
%Limits Not-Set	14%	94%	0%
Limits Incorrect	0	0	6,570
%Limits Incorrect	0%	0%	92%