Compartmentation in Qlik Sense Table for calculation

[sharanqlik]

Hi All,

I am facing a scenario where I need to show measure value only if its not already shown in earlier (or later) row with condition.

Consider below input data -

Product	Theme	Type	Value
A	Credit	Credit	100
A	Credit	Equity	100
A	Credit	General	100
B	Equity	Real Estate	50
B	Equity	General	50

Here Theme of product is always same but Type changes as per sale. The output I want in visualization is -

Product	Theme	Type	Value
A	Credit	Credit	100
A	Credit	Equity	0
A	Credit	General	0
B	Equity	Real Estate	0
B	Equity	General	50

Meaning -

For any product, If Theme = Type then show value ( as first row for product A) else for any product if Theme and Type never match then show value in front of General Type (as second row of product B). Notice that third row of product A is value 0 because there is already a Theme and Type match for product A which is not there in product B.

[sharanqlik]

Thanks Vincent. This worked as expected.

I am still making some adjustments but this solved the problem, thanks.