Hide if values are null or zero in Qlik pivot tables

[alexshaji]

Hello Experts,

I have requirement where I am showing the % of sales of products half yearly back from FY19 onwards. So my expression is something like this. And I have around 100 products however some products were relevant only FY19 and some only FY20 and so on. However while displaying the data all the 100 products are now being displayed for every half even thought it has no values or zero values or even not relevant for that half. Can anyone help me out to show only the relavant product for the particular half? or at least can we hide the values if it is zero? 

Sum({<[Product Category] ={'Product1'}>}Sales_Amount)
/
Sum(Sales_Amount) 

[Or]

Check both the "Suppress Zero-values" and "Suppress null" boxes under Presentation (the latter should be checked by default, I believe).

[alexshaji]

I am sorry if I did not specified the tool correctly. My requirement is in Qlik sense.

[alexshaji]

can anyone help me out on this???

[alexshaji]

Does that mean we do NOT have a solution for this?