Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Valued Contributor III

what is the reason?

Hi all,

i have a different issue   i just want to know the reason behind that

i have  a filter with  market and  country    and  one pivot table     if i select   one country and one market value   

the sum(value) =0   which is correct but     the table is showing  zero   as a result.

my req:  is   table should not show anything  empty table should show,reason.PNG

Tags (3)
2 Replies

Re: what is the reason?

From Layout tab, Disable the feature called "Size to Data"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: what is the reason?

Hi Sony,

I think you need to surpress zero values:

Open Properties, Register "Dimension", then "surpress 0-values":


Hope this helps.