How to remove zero value column in a pivot table

[tanuja]

Hi Guys,

I have to create a Pivot Table to show Quarter-wise data, while adding the measures(q1,q2,q3,&q4) i am getting zero value columns for each quarter. I need to remove these columns, can anyone tell me ho two remove the zero value column in qliksense pivot table.

below I have attached the image.

[Chetan_MN]

Hi @tanuja Can you try unchecking "include zero values"

[tanuja]

Already done that it works for the rows. i need to remove zero value COLOUMN. 

[Aasir]

Click on the dimension label (e.g., Quarter) to access its settings, then enable "Suppress Zero Values" or a similar option under the "Limitations" section. This setting hides columns where all measures are zero or null.