topic Re: Hide one Row in Pivot Table in QlikView

Hide one Row in Pivot Table

cristian_av — Thu, 29 Dec 2016 12:18:10 GMT

I need to hide just ONE row in a pivot table, but only when expanded. When contracted, it has to sum the value! Is that possible? Any hack or any idea?

Thanks!

Re: Hide one Row in Pivot Table

sunny_talwar — Thu, 29 Dec 2016 12:21:42 GMT

Would you be able to share your qvw file to test this out?

Re: Hide one Row in Pivot Table

migueldelval — Thu, 29 Dec 2016 12:37:33 GMT

Hi Kjh,

Is your value null? If it´s null you only need to check in "Suppress When Value Is Null" at Dimenssion Tab.

Regards

Miguel del Valle

Re: Hide one Row in Pivot Table

vinieme12 — Thu, 29 Dec 2016 12:37:52 GMT

use Dimensionality() value

Re: Hide one Row in Pivot Table

cristian_av — Thu, 29 Dec 2016 12:43:51 GMT

Is not Null. I can make it null (it's a value calculated in load script), but if I make it null, it dissapears, but when I contract the dimension, the sum don't consider it!

Re: Hide one Row in Pivot Table

cristian_av — Thu, 29 Dec 2016 12:45:40 GMT

I can't.. it has data from a customer!

Re: Hide one Row in Pivot Table

sunny_talwar — Thu, 29 Dec 2016 12:46:43 GMT

May be share mocked up data my friend or look here:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Hide one Row in Pivot Table

vinieme12 — Thu, 29 Dec 2016 12:47:51 GMT

see this thread for ideas

PIVOT - One row in details that has not to be showed

Re: Hide one Row in Pivot Table

vinieme12 — Thu, 29 Dec 2016 12:48:26 GMT

just upload some dummy inline data to work with