This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 ?
thank you for your collaboration
The case is closed
I made a stupid mistake and confused 2 flags
1 is a normal result
View solution in original post
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.