Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
bcjavier
Partner
Partner

Count in Chart Function not returning the exact value

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

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
MVP
MVP

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])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
bcjavier
Partner
Partner
Author

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