# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Custom list of products

Good day

I want to create a custom list of Products with sales. The items with no sales must also be reflected on the sheet. I have the set analysis expression below, but only the items with sales reflect. I need to see a zero against those items that have no sales.

How do I amend this expression?:

Sum({\$<[Product Code]={'1023','2014','1029','MKD-02','SM190'},Year={\$(vMaxYear)}>}Quantity)

Kind regards

Chandran

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Contributor II

@tresesco Ok. Thank you for your assistance.

10 Replies
MVP

@chandran Try like:

Sum({\$<[Product Code]={'1023','2014','1029','MKD-02','SM190', "=Sum(Quantity)=0"},Year={\$(vMaxYear)}>}Quantity)

Contributor II

Hi Tresesco,

I am getting items that are not on the list. See below. I only need to see the items as per the set analysis.

MVP
The items with no sales must also be reflected..

@chandran  you are seeing these extra products because that have zero sales and I thought that that was your requirement. Could you explain a bit more may be with an example?

Contributor II

@tresesco My custom list of products are eg.1,2,3,4,5. I want only these items to show on my sheet ( no other items).

The sheet should look something like this:

Product Code                   Qty Sold

1                                                   10

2                                                   20

3                                                    0

4                                                   50

5                                                      0

Hope this makes sense of my requirements.

Kind regards

Chandran

MVP

@chandran , that means some items with zero values are getting suppressed. So you just need to enable zero inclusion, like:

Contributor II

@tresesco I have that ticked

MVP

@chandran Could you share your sample app?

Contributor II

@tresesco  Unfortunately I cannot for security reasons. Could you perhaps do some testing on your app?

MVP

I can. However,  I suspect that the issue would be with your app or the way you are trying to get that. So an app from my end would not help.😐