Count in Chart Function not returning the exact value

[bcjavier]

Hi!

I am new to Qliksense. I have a problem using the count function. It doesn't return the exact value that I needed. Here is the expression:

Count({<[deferred={'1'}>]}[id]) the value that this expression returns is 98,402 but I am hoping for 118,346.

I just simply count the ID where the value of deferred is equals to '1'

Thank you for your kind help!

javier

[Vegar · Accepted solution]

Your count() function should return your expected result. Could it be a syntax typo that is causing your error? Try this:

Count({<[deferred]={'1'}>}[id])

[bcjavier]

The database was updated. That's why the value changes. Thank you.