Sum or total the count of an 'if' expression

[#1]

Hi,

I want to represent the following statement as a single number in a dashboard and not as a table:

if (count ({<Delivered -= {'0'}>}distinct Account)='0', count(Account), 0)

I've been able to do this previously with a normal 'count' statement by creating a Chart | Straight Table without any dimensions - this seems to total (sum) the results.  The above statement just comes up with a blank.

Thanks for any help.

[jagan]

Hi,

Try this in Text Object instead of Straight table

=if (count ({<Delivered -= {'0'}>}distinct Account) = 0, count(Account), 0)

Regards,

Jagan.

[#3]

Thanks Jagan - I didn't know the Text box could do that.

Appreciate your help - only problem is, it is returning a zero value.  Any ideas? or would i need to upload my data?

[CELAMBARASAN]

Which version of Qlikview desktop your are using?

Hope the below expression could help

if (count ({$-<Delivered = {'0'}>}distinct Account)=0, count(Account), 0)

[jagan]

Hi,

Upload your qlikview file and expected output values.

Regards,

jagan.

[Joseph_Musekura]

Hi,

Can you try the expression

1. Without the  modifier if (count ({$}distinct Account)=0, count(Account), 0)

2.   and  if (count ({1}distinct Account)=0, count(Account), 0)

3. Then add  a modifer if (count ({$ <Delivered = >}distinct Account)=0, count(Account), 0).  and so on...

    This could help to identify why you are getting 0

Regards,