Restricting Calculations when Selections are made

[LebogangT]

I have a Qlik Table which shows different dimensions and measures when selections are made. I got a request to only show a zero value, when these selections happen, the 'Sales Budget'  measure and Dimension 'Products' are selected. 

I tried using the following expression

if([_dimension] = 'Products' , Budget_Value = '0' , (sum({$<PD_Year_Num = {$(_vMaxYear)}>}[Budget_Value])))

but the issue is when other dimension are selected then values show again. The zero value should remain when the 'Sales Budget'  measure and Dimension 'Products' are selected even if they add other dimensions.

[brunobertels]

hi

May be this 

if([_dimension] = 'Products' AND  Budget_Value = '0' , sum({$<PD_Year_Num = {$(_vMaxYear)}>}[Budget_Value]))

[jbhappysocks · Accepted solution]

Hi

Try something like 

if(index(concat([_dimension],'|'), 'Products'), 0 , (sum({$<PD_Year_Num = {$(_vMaxYear)}>}[Budget_Value])))

Without really understanding how you want your table to function this should at least result in 0 when Products is selected.

[LebogangT]

This worked like a charm, thank you so much