Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Learnerr
Contributor III
Contributor III

Ignoring Blank Values in Pivot Table

Hi all,

 

I have a pivot table but i dont wanna see the blank values of my dimension. How can i ignore them .

 

Regards

 

 

Learnerr_1-1661167707342.png

 

1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Perhaps suppressing null values as shown below

peter_brown_1-1661168073769.png

 

 

View solution in original post

4 Replies
BrunPierre
Partner - Master
Partner - Master

Perhaps suppressing null values as shown below

peter_brown_1-1661168073769.png

 

 

Learnerr
Contributor III
Contributor III
Author

Hi Peter_brown 

 

Thanks for the info. It works.

 

Have a nice day!

BrunPierre
Partner - Master
Partner - Master

Cheers!

Lakshminarayanan_J

@Learnerr 

Kindly set the field value as below

Lakshminarayanan_J_0-1661171265029.png

 

or 

Check the below link it will be helpful,

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button