Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
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)

Please assist.

Kind regards

Chandran

Labels (1)
1 Solution

Accepted Solutions
Contributor II
Contributor II

@tresesco Ok. Thank you for your assistance.

View solution in original post

10 Replies
MVP
MVP

@chandran Try like:

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

Contributor II
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.

 

chandran_0-1605161263143.png

 

MVP
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
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
MVP

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

tresesco_0-1605162676057.png

 

Contributor II
Contributor II

@tresesco I have that ticked

MVP
MVP

@chandran Could you share your sample app?

Contributor II
Contributor II

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

MVP
MVP

@chandran 

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.😐