Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gal_polak
Creator
Creator

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
Creator III
Creator III

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)

View solution in original post

2 Replies
sibin_jacob
Creator III
Creator III

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)

Anil_Babu_Samineni

Take entire fields in table and show the image?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)