hide row pivot table

[#1]

How do I hide a row in a PivotTable. For example:

I have a table with a dimension and a measure

Dimension      Measure

A                         10

B                         50

C                         45

I would like to hide the size equal to 'B'.

[Chanty4u]

chk dis

Hide rows in Pivot Table

[sunny_talwar]

You can either use set analysis in your Measure or calculated dimension to restrict data.

Expression-> Assuming you are using Sum(Measure), you can change it to Sum({<Dimension -= {'B'}>} Measure)

Calculated Dimension -> If(not Match(Dimension, 'B'), Dimension) and select 'Suppress When Value Is Null' option on the dimension tab of the chart properties

Set Analysis method is ideally a better approach but will have to be implemented to all the rows. So if you have a lot of expressions, you can consider using Calculated Dimension.

[reddy-s]

Hi Thiago,

Sunny's reply will work in Qliksense as well.

[#5]

But I can implement this example in PivotTable QlikSense? For I have not found the 'Suppress When Value Is Null' option but table properties.

[#6]

I found the 'Suppress When Value Is Null' option in the PivotTable properties in Qlik Sense

[sunny_talwar]

Did you find it or no?

[#8]

You know inform the PivotTable Qlik Sense possesses the option 'Suppress When Value Is Null'?

[sunny_talwar · Accepted solution]

Qlik Sense's alternative to 'Suppress When Value Is Null' is 'Show null values' under the dimension section

I guess to remove nulls, try unchecking this

[mansoorsheraz]

Hi, I have a similar situation but when I do this it removes the complete top group. The detail question is posted here :
https://community.qlik.com/t5/New-to-Qlik-Sense/Selective-Dimensions-in-Pivot-Table/m-p/2031109

Any help is appreciated.