Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (1)
1 Reply
mruehl
Contributor III

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

Try this:

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

Community Browser