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: 
mrichman
Creator II
Creator II

How to use set analysis with if statement?

Hi Community,

How can I best approach the following issue. I have two fields, which likely have the same values (type1 and type2) and want to count based on customer ID.

Example:

Data:

LOAD * inline [

Customer|Type1|Type2

Astrida|TV|Radio

Astrida|TV|Ref

Astrida|TV|TV

] (delimiter is '|');


In word: only count Customer if Type1 and Type2 have the equal field, and ignore all rows which do not comply with the formula.


Thanks in advance.


1 Solution
2 Replies
mrichman
Creator II
Creator II
Author

Hi Sunny, thanks. Some lag occured.