topic Show all values in QlikView

Show all values

Fri, 24 Aug 2012 13:49:12 GMT

Hi all,

I've got something that I cannot find how to do.

I've made 2 pivot tables, both have the same dimensions: Week and City.

In the first, I have the expression sum(Turnover).

In the second, the expression is Count(DISTINCT InvoiceId)

for weeks 33, 34 and 35, turnover number of invoices are 0.

When I select 2012 as year and august as month (weeks 33, 34 and 35 belong to august),

in the first pivot table I get a column for all the weeks, including 33, 34 and 35, where I get all 0-s. This is GOOD.

In the second pivot table however, those weeks are not displayed, but I want them to be displayed with 0's.

If I check the 'show all values' for the dimension week, I also get all the weeks that aren't related with the month I selected.

It seems there is a diference depending on the fucntion I use (sum or count).

Any one an idea how I can get this to work with the count?

Regards,

Yves

Nicole-Smith — Fri, 24 Aug 2012 14:11:20 GMT

Make sure that Suppress Zero Values is NOT checked:

Fri, 24 Aug 2012 14:21:18 GMT

That toggle is not checked. I've testing and looking further and the case is a little different from what I described.

You can forget what I wrote about the sum(Turnover) working. It had nothing to do with this problem.

The weeks with 0 are displayed when I use the function:

count(DISTINCT InvoiceId)

The weeks with 0 are not displayed when I use set analysis in that function. For example:

count(DISTINCT{$<SOORT={'30'}>} InvoiceId)

Fri, 24 Aug 2012 14:32:10 GMT

Is SOORT part of the invoice table? Set could be returning null if this is the case for the 0 invoices

Wed, 29 Aug 2012 11:29:32 GMT

yes it is