Pivot table alignment issue

[bushpalaamarnat]

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.

[jubarrosor]

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

[Anonymous]

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

[bushpalaamarnat]

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%