Left join in set analysis?

[qlikeers]

Hi!

I have a table as in the example.

Is it possible to get the expected table in set analysis?

The point is that I need to create a list of products with one exclusion (days) first, and then add the sum of value (for a date) to those products without the exclusion (as in the example). All from one table.

How can this be done?

[qlikeers]

I wrote the SQL only to show what I would like to achieve the end result. I would like to do this on the front-end. I think your idea is good, but I have no idea how to adapt it.

[qlikeers · Accepted solution]

I guess I found a solution to the problem and it was easier than expected 🙂

Dimensions:
- Days
- ProdId

Measures:
sum(
{
<
[ProdId]=p({<[Days] = {">=5"}>} [ProdId])
>
} [Value])

Useful stuff [CLICK] 

Thanks again for your help!