Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression in KPI

Hi ,

I want to ask why i keep getting negative value when using expression Sum(status='fail').

Here are the attachment for the expression that i use.

The total should be in positive value because i want to count the total in subject english and science.

2016-04-05 11_42_25-a - My new sheet _ App overview - Qlik Sense.png2016-04-05 11_42_55-Subject - Excel.png

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Count({<Status = {'fail'}>} status)

View solution in original post

2 Replies
sunny_talwar

Try this:

Count({<Status = {'fail'}>} status)

Not applicable
Author

Tq for your help..