Discussion board where members can get started with Qlik Sense.
I built an Qlik Sense App and faced a strange behaviour, but no doubt someone will highlight my misunderstanding
My table has 50 records, 1 unique record by Id
for each record, i add a flag value 0 or 1 according some other field interpretation
when I use a KPI or TEXT object using sum(Flag) I get 1
if I use a count(disitnct Id) I get 50
When I select Flag = 1, and count(distinct Id) I get 14 which is the number I should have with sum(Flag)
So I don't underrstand why sum(Flag) returns 1
Any idea ?
Go to Solution.
thank you for your collaboration
The case is closed
I made a stupid mistake and confused 2 flags
1 is a normal result
Is it posssible to attach a sample qvf file so that it will be easy to solve the issue.
If you need the KPI to only count records with flag=1 then
Try COUNT(ALL Flag) the lack of Aggregation I think is what's causing your issue. SUM wont work as your flag I assume has 0 on the other side.
Glad you sorted it.