Skip to main content
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..