topic Re: Pivot Table Issue in QlikView

Pivot Table Issue

Tue, 19 Aug 2014 14:15:52 GMT

Hi All,

I came across this weird issue when using the pivot table. My pivot table is as follows

As you can see the 2nd column can be expanded as required. My problem is when I try expanding the record highlighted in red, the green record also expands. Reason being the field values being the same. I only require the relevant record to be expanded.

I don't know if this is a common issue in the pivot table but if so what is the workaround?

Can anyone help on this matter?

Thanks!

Re: Pivot Table Issue

Tue, 19 Aug 2014 15:51:57 GMT

can you please check both records data containing fields (In time and Breached) from your table.

Re: Pivot Table Issue

JonnyPoole — Tue, 19 Aug 2014 16:18:01 GMT

Bit of a guess ... is it different with aggr( Target, Description) as the 2nd dimension ?

Re: Pivot Table Issue

Wed, 20 Aug 2014 07:55:28 GMT

Hi Sanjeev,

The data sets for the In Time and Breached are different.

Re: Pivot Table Issue

Wed, 20 Aug 2014 07:56:11 GMT

Hi Jonathan,

Unfortunately it doesn't work. But thanks for the suggestion.

Re: Pivot Table Issue

Wed, 20 Aug 2014 11:15:17 GMT

Found it! The field 'Target' was included in a dual function. A unique number was given for each Target. Works like a charm.

Special thanks to Brittany Petit's post which gave me the insight into what should be done:

http://dvtrenches.wordpress.com/2011/06/03/ungrouping-in-pivot-tables