Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

need help in a pivot table??

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

3 Replies
alfasierra
Contributor II

need help in a pivot table??

Hi,

did u try   sum(  {1} fail)?

sushil353
Honored Contributor II

need help in a pivot table??

Thanks Buddy

Not applicable

need help in a pivot table??

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

Community Browser