Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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% |