Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
timmy
Partner - Contributor III
Partner - Contributor III

Transform if into set analysis

Is it possible to solve this with a set?

=sum(if(Dos_HoofdId <> Dos_Id,1,0))

tnx

2 Replies
Anonymous
Not applicable

what do you want to reach? if you need to count rows/records where Dos_Hoofdld not equal to Dos_Id, then you can use count function in field, where always will be a value

AT

Not applicable

Timmy, we need more info, you could add your statement in the script and then sum the fields, or possibly use the exists function. With the info provided the If function would do the job you do not always have to use sets.

What is the expression in relation to?

regards,

Neil