topic presentation of pivot table in QlikView

presentation of pivot table

sushil353 — Mon, 29 Aug 2011 10:24:55 GMT

Hi all,

I need to create a pivot table in such a way that there should be pivot table for each location(where location is dimension). Please look into the image below..

In first image there are Operation,test name, measurement, and some calculation is done.. so i need each such kind of table for each location as shown in image 2. in image 2 celestica monterry and flextronics is locations..

Please share your ideas to solve it...

Thanks

presentation of pivot table

Mon, 29 Aug 2011 10:37:59 GMT

Hi,

add loaction as first dimension in the pivot table.

Niranjan.

presentation of pivot table

Mon, 29 Aug 2011 10:40:01 GMT

Hi,

If this was not a Pivot chart then using Trellis option in dimension tab you can do that.

For pivot there is no trellis.

You can do one thind use a variable as first dimension in pivot chart. This variable have selected value from input box.

This way you can show for each location but one at a time.

HTH

presentation of pivot table

sushil353 — Mon, 29 Aug 2011 10:56:51 GMT

Hi shubhu,

can you please explain a bit more.. if possible with some steps/examples

Thanks