topic need help in a pivot table?? in QlikView

need help in a pivot table??

sushil353 — Fri, 18 Nov 2011 07:32:24 GMT

Hi all ,

In my dashboard i have a pivot table in which some calculations are done over some operations and location.

i have OPERATION and LOCATION in separate field as well....

i want to show results in pivot table for all operations and for all locations...irrespective to the selection made from fields..

but whenever i select any operation or location from the separate field the pivot table got filtered according to the selection (normal behaviour of QV)

the sample application is attached....

Please help me to solve this problem..

Thanks

Sushil

need help in a pivot table??

Anonymous — Fri, 18 Nov 2011 08:07:12 GMT

Hi,

did u try sum( {1} fail)?

need help in a pivot table??

sushil353 — Fri, 18 Nov 2011 08:11:48 GMT

Thanks Buddy

need help in a pivot table??

Fri, 18 Nov 2011 08:15:21 GMT

Hi,

You have 2 options to do that

1) detached tha chart (properties--general tick on detached)

2)try this sum({1}fail) and sum({1}process)

Hope this will help you.

Thanks & Regards

Upendra