Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gal_polak
New Contributor II

problem - Count present 1 even when the table is empty

Hi,

I'm trying to do a simple count, but i noticed that when i have not data in the table, the count present value of 1

when i do have data in the table everything works perfect.

What am I missing??

I tried all of those scripts, but non of them worked:

1. Count(distinct ChallengeId)

2. Count({<[Challenge Status]={'Active'}>} distinct ChallengeId)

3. if(isnull(ChallengeId),0,count(distinct ChallengeId))

as you can see the table is empty

2018-08-09_16-37-58.png

but i still get value of 1

2018-08-09_16-39-43.png

1 Solution

Accepted Solutions
sibin_jacob
Contributor III

Re: problem - Count present 1 even when the table is empty

all the tables are empty or only the "Challenges" table?

as it is a key column, it will show value, if any of the one table having records.

can you check count for an another column in the "challenges" table.

For ChallengesChallengeId column:

Count(distinct ChallengesChallengeId)

2 Replies
sibin_jacob
Contributor III

Re: problem - Count present 1 even when the table is empty

all the tables are empty or only the "Challenges" table?

as it is a key column, it will show value, if any of the one table having records.

can you check count for an another column in the "challenges" table.

For ChallengesChallengeId column:

Count(distinct ChallengesChallengeId)

Re: problem - Count present 1 even when the table is empty

Take entire fields in table and show the image?