topic Restricting Calculations when Selections are made in App Development

Restricting Calculations when Selections are made

LebogangT — Wed, 04 Jan 2023 13:43:18 GMT

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.

Re: Restricting Calculations when Selections are made

brunobertels — Wed, 04 Jan 2023 14:57:43 GMT

May be this

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

Re: Restricting Calculations when Selections are made

jbhappysocks — Wed, 04 Jan 2023 15:42:18 GMT

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.

Re: Restricting Calculations when Selections are made

LebogangT — Thu, 05 Jan 2023 07:17:54 GMT

This worked like a charm, thank you so much