topic Re: Straight table display '0' for Count expression in QlikView

Straight table display '0' for Count expression

Wed, 21 May 2014 08:00:32 GMT

Hi, I'm using straight table, which consists of 3 columns (Month,site,name), to count the duplicate rows for each distinct row by the expression 'TotalCount(Month)'. There are some months which do not have any data in the other 3 columns so it's only the 'Month' column displaying the months, but the TotalCount(Month) column, that counts the duplicate rows for each distinct row, displays '1'. Is there any way I can change it to '0'? As I want to display all the months to avoid confusion as to why not all months are displayed. Example below. Thanks.

current:

Month	Site	Name	TotalCount(Month)
01/2012	AS	A	5
01/2012	XD	C	21
02/2012	-	-	1
03/2012	-	-	1

I want it to be:

Month	Site	Name	TotalCount(Month)
01/2012	AS	A	5
01/2012	XD	C	21
02/2012	-	-	0
03/2012	-	-	0

Re: Straight table display '0' for Count expression

Anonymous — Wed, 21 May 2014 08:08:54 GMT

Can you share your app with dummy numbers?

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:17:30 GMT

Sorry? I dont get it.

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:18:00 GMT

Change the TotalCount(Month) expression with this:

=if(GetPossibleCount(Site)+GetPossibleCount(Name)>=2, TotalCount(Month), 0)

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:29:52 GMT

if i add in one more column will it still be '>=2'? or will it be '>=3'?

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:33:02 GMT

No, still didnt get 0...but thanks:)

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:33:14 GMT

Yes!

Re: Straight table display '0' for Count expression

its_anandrjs — Wed, 21 May 2014 08:40:30 GMT

Write a expression like

=If(Count(Month) = 1, 0, Count(Month) )

And in presentation properties >> Uncheck the Suppress Zero-Values

Other wise you can add a field in the load script also let me know.

Re: Straight table display '0' for Count expression

Wed, 21 May 2014 08:43:47 GMT

But thr r rows where all columns are filled but only appeared once in the dataset so for some cases, '1' is correct.