Qlik - Flag to filter out dimension based on occurrence

[Shivam22]

Hi All,

I have a data set like below

YearMonth	Product	SubProduct	SalesMan	Count
Jan-25	Car	Tire	John	20
Jan-25	TV	Remote	Jason	25
Jan-25	Fridge	filter	John	34
Feb-25	Car	Tire	John	20
Feb-25	TV	Remote	Jason	56
Feb-25	Car	Seats	Aaron	36
Mar-25	TV	Remote	Jason	37
Mar-25	Fridge	filter	John	38
Mar-25	Car	Tire	Aaron	39
Apr-25	TV	Remote	John	40
Apr-25	Car	Tire	Mark	42

When I select Fridge, I should be able to show in table on frontend where in Feb2025, Apr-25 John dint do any sales for Fridge, same when I select TV I should be able to show Jason dint do any sales in Apr,2025 etc

Also, when I select Tire, i should be able to show in a table in front end where in Mar 2025 and Apr 2025 John dint do any sales, and when i select Remote - Jason dint do any sales in Apr 2025.

Can anyone please help me to achieve this?

Thanks in Advance!

[hanna_choi · Accepted solution]

Hello @Shivam22 

How about this?

This case Modelling is required.

First, I make a master table for YearMonth, products, sub-products, and salesman .

And I joined the sales information you presented.

[unselect] 

[select] 

[Data Load Editor]