Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis, If customer purchase one of the product groups/ Proritization

Dear QV user,

I would like to ask for some help. I need to prioritize customers that purchase one of the three product groups (ex. proteins or calcium or magnesium). I thought I can do it by usage of set analysis, but cannot come with proper formula. I would like to include in a table extra column, that says 'yes' if customer purchased proteins or calcium or magnesium, otherwhise 'no'. Any ideas? Customer name is my dimension.

Thank you in advance,

Beata

1 Reply
mruehl
Partner - Specialist
Partner - Specialist

Try this:

=IF(SUM($<{PRODUCTGROUP={A,B,C}>}TURNOVER)>0,'YES','NO')