Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Kelvin93
Contributor
Contributor

Create Matrix with flag if exist

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:

Kelvin93_0-1635516286378.png

The tables looks like:

Kelvin93_1-1635516445120.png

How can i achive this with qlik?

 

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner
Partner

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)

AshutoshBhumkar_1-1635518132183.png

 

 

Thanks,

Ashutosh

 

View solution in original post

2 Replies
AshutoshBhumkar
Partner
Partner

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)

AshutoshBhumkar_1-1635518132183.png

 

 

Thanks,

Ashutosh

 

Kelvin93
Contributor
Contributor
Author

Thanks, it works perfectly