Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

hide row pivot table

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'.

1 Solution

Accepted Solutions
MVP
MVP

Re: hide row pivot table

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

Capture.PNG

I guess to remove nulls, try unchecking this

8 Replies
sureshqv
Esteemed Contributor III

Re: hide row pivot table

MVP
MVP

Re: hide row pivot table

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.

Capture.PNG

reddys310
Honored Contributor II

Re: hide row pivot table

Hi Thiago,

Sunny's reply will work in Qliksense as well.

Not applicable

Re: hide row pivot table

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

Not applicable

Re: hide row pivot table

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

MVP
MVP

Re: hide row pivot table

Did you find it or no?

Not applicable

Re: hide row pivot table

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

MVP
MVP

Re: hide row pivot table

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

Capture.PNG

I guess to remove nulls, try unchecking this