Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Product Loss in Table

Refer : https://community.qlik.com/t5/New-to-Qlik-Sense/Product-Loss-in-Table/m-p/1614107#M143806

Concat({<Product = P({<Year = {2017}>} Product) * E({<Year = {2018}>} Product)>} DISTINCT Product, ',')

The above expression is working fine

But when i select one customer but expression not working properly

@jontydkpi 

My Concept is Product Loss (i.e)

If I select 2018 and one customer (Customer A ) in a filter then i want to take 2017 sold product to that customer and compare with 2018 sold product if doesn't exist then i want to shown that item

 

2 Replies
Highlighted
MVP
MVP

Re: Product Loss in Table

>>If I select 2018 and one customer (Customer A ) in a filter then i want to take 2017 sold product to that customer and compare with 2018 sold product if doesn't exist then i want to shown that item

Its not really clear what is wrong. If you select one customer, then the filer is applied in the context of that customer. If you want something different, you can override one or more parts of the filter to ignore the customer selection.  For more specific guidance, i suggest you provide a small app with some sample data and what you would like to see as output -- with or without customer selection(s).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor

Re: Product Loss in Table

Sorry Jonty...It's my mistakes while writing an expression. Now its working perfectly.