Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vquin001
New Contributor

Need help with grouping data while excluding others

I need help in summarizing information based on a product's sales result. Example is below, I need to see how many Nintendo customers buy Xbox products and how many Non-Nintendo customers buy Xbox products, the grouping is based on Nintendo customers. Both Nintendo and Xbox are in the Product field. Thanks.

                                         Products

Customers                Nintendo     Xbox

Cust 1                        $5                $10

Cust 2                        $0                $15

Cust 3                        $0                $15

Cust 4                        $15              $0

Nintendo customers   $15       $10

Non-Nintendo             $0         $30                                                                        

2 Replies
siddharth_s3
Contributor

Re: Need help with grouping data while excluding others

Please give a snapshot of how the data model looks like?

vquin001
New Contributor

Re: Need help with grouping data while excluding others

Thank you but I think I found a workaround.