Create Matrix with flag if exist

[Kelvin93]

Hi, i've 2 tables, one with my articles db and the second with a promoid and the articleid. I wanna create something like this:

The tables looks like:

How can i achive this with qlik?

[AshutoshBhumkar · Accepted solution]

Hello,

Try like below.

Create a link between both tables on ArticleID.

Take a pivot table, Rows: Article, ArticleDescription. Column : PromoID

Measure : Count(Distinct PromoID)

Thanks,

Ashutosh

[Kelvin93]

Thanks, it works perfectly