Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
MVP
MVP

Re: Expression in KPI

Try this:

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

2 Replies
MVP
MVP

Re: Expression in KPI

Try this:

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

Not applicable

Re: Expression in KPI

Tq for your help..