topic Re: Cells with zero values in QlikView

Cells with zero values

Wed, 20 Jan 2016 11:06:36 GMT

Hi all, anyone can help me?

In a Pivot Table I show the data of sales of each agent and each client. If I select a year, disappear the data related to the customer who did not have sales for the year selected. How can I do to show even customers without sales for the year selected by setting 0 in sales?

Thank All

Re: Cells with zero values

sunny_talwar — Wed, 20 Jan 2016 11:08:27 GMT

May be you need to go to presentation tab and uncheck 'Suppress Zero-Values' option

Re: Cells with zero values

Wed, 20 Jan 2016 11:20:43 GMT

hi Sunny T

Thank you for your help. I tried but not working.

When I select the year, they disappear the lines for customers who have no sales in the selected year.

Re: Cells with zero values

israelcsouza — Wed, 20 Jan 2016 12:54:19 GMT

Hi Marino,

May be you need to go to Dimensions Tab and check 'Show All Values' option:

Re: Cells with zero values

awhitfield — Wed, 20 Jan 2016 14:30:59 GMT

Hi Marino,

can you upload an example .qvw please?

Andy

Re: Cells with zero values

florentina_doga — Wed, 20 Jan 2016 14:43:10 GMT

!hi,

i find a solution for your problem.

Re: Cells with zero values

settu_periasamy — Wed, 20 Jan 2016 15:02:54 GMT

Hi,

May be try these steps :

'Show All Values' in the Dimension tab.

In the Presentation tab

Uncheck 'Suppress Zero-Values'

Null Symbol -> set as 0

Missing Symbol -> set as 0

Re: Cells with zero values

Tue, 26 Jan 2016 13:04:40 GMT

Thank very, very.....