Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'.
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
chk dis
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.
Hi Thiago,
Sunny's reply will work in Qliksense as well.
But I can implement this example in PivotTable QlikSense? For I have not found the 'Suppress When Value Is Null' option but table properties.
I found the 'Suppress When Value Is Null' option in the PivotTable properties in Qlik Sense
Did you find it or no?
You know inform the PivotTable Qlik Sense possesses the option 'Suppress When Value Is Null'?
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
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.