Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering rows with IF expression in which one value does not exist

Hi!

I'm trying to build and expression to find out all the people who do not finished any courses for which they get CourseCredits. In my data model the CourseCredits field is linked to many statuses (such as failed and planned) and so I need to filter out all the rows with the Status 'Done'.

I tried the following expression but it just filters out the Status values 'Done' whereas I want to filter all the people who do not have Status 'Done':

= sum(if(Status <> 'Done', CourseCredits, 0))

Could somebody help me out what I should use here?

All the best,

Mikael

2 Replies
narender123
Specialist
Specialist

Hi,

Try this.

= if(Status <> 'Done', Sum(CourseCredits), 0)


also in Total Mode

check "Sum og Rows"

Thanks.

Gysbert_Wassenaar

This filters out all the PersonID's that do not have a status Done, leaving only those persons that finished at least one course:

sum({<PersonID=p({<Status={'Done'}>}PersonID)>} CourseCredits)


This filters out all the PersonID's that do have a status Done, leaving only those persons that did not finish any course:

sum({<PersonID=e({<Status={'Done'}>}PersonID)>} CourseCredits)


Replace PersonID with the field that identifies your persons.


talk is cheap, supply exceeds demand