Force Qlikview table to diplay all values

[mohamed_ahid]

Hi all ,

i have a question about a table on qlikview .

in my data model i have a schema like this one .a customer table and their sales.

i want to achieve a table which display customer and their sales even thoses who don't have sales (display 0 ) . how can i do that ?

thanx

[#2]

Attach may help u

[Siva_Sankar]

pfa

[mohamed_ahid]

Thx naga1234 ,

But the issue is that QV automatically handl this on a normal table  (juste dimension ). in my exemple i'm using a pivot table with expression(sum of sales for this year -sum of sales for last year...)

what i want is display all the customers even those with null sales ?

[Siva_Sankar]

in presentation tab, uncheck 'suppress zero values' option.

[Anonymous]

Try adding another expression =sum({1} Sales) and then hiding the column (in the presentation tab)

[Siva_Sankar]

PFA. It shows zero values in pivot table too.

[qlikpahadi07]

Hi,

you can made two changes in Expression just unselect the option which is 'suppress zero values'

And in Dimension select "Show all Values"

Hope this Helps you

[mohamed_ahid]

thx all for responding but still not getting a solution .

i have tried all the tricks below but any one works .

a normal sum() like in community exemple is working fine , but in my case i'm using a set analysis .

the only solution in my point of view is to add sales with value 0 .

what you think ?

[qlikpahadi07]

It shud work .....Can you attach your Application ?

will be helpful