topic Re: Include/Exclude Zero Values Dynamically in App Development

Include/Exclude Zero Values Dynamically

Kailash_Shaw — Tue, 23 Aug 2022 09:26:04 GMT

Hey!

I need a help to Include/Exclude Zero Values Dynamically. Probably based on Button/Variable Input selections.

I have this Pivot where 'Canutility' - 'DD' has 0 for both the measures. I can add/remove that row if 'Include Zero Values' button is checked/unchecked.

Can we achieve this with button on the front end? Clicking that button will include/exclude zero values.

Please suggest.

Re: Include/Exclude Zero Values Dynamically

Or — Tue, 23 Aug 2022 09:28:16 GMT

I am not familiar with a way to do this directly, but you could consider a show/hide container containing two copies of the same object, one with zero values included and one without, and toggle them based on a button or whatever other condition. This does require you maintain two objects, though...

Re: Include/Exclude Zero Values Dynamically

Kailash_Shaw — Tue, 23 Aug 2022 09:34:02 GMT

Thanks @Or, I will try that if app size permits.

Re: Include/Exclude Zero Values Dynamically

Or — Tue, 23 Aug 2022 09:38:51 GMT

The impact an extra object has on app size is negligible, so that shouldn't be a problem. It's mostly the issue of maintaining two objects and potentially the issue of using a container and master items (which makes it harder for users to edit the object after duplicating, if that's a consideration).

Re: Include/Exclude Zero Values Dynamically

Kailash_Shaw — Tue, 23 Aug 2022 09:40:51 GMT

Oh ok, got it, thank you!

Re: Include/Exclude Zero Values Dynamically

MayilVahanan — Tue, 23 Aug 2022 09:40:55 GMT

Try like attachment.

Hope it helps

Re: Include/Exclude Zero Values Dynamically

Kailash_Shaw — Tue, 23 Aug 2022 10:07:05 GMT

Thanks @MayilVahanan
One query, how to make it work if I have multiple dimensions into table?
I am pasting your dimension expression here for quick reference.

=Aggr(If(vHideZeroValue = 1, if(Sum(UnitPrice)+Sum(UnitSales)>0, Product), Product),Product)

Re: Include/Exclude Zero Values Dynamically

MayilVahanan — Wed, 24 Aug 2022 02:43:54 GMT

Try like below,

Hope it helps

=Aggr(If(vHideZeroValue = 1, if(Sum(UnitPrice)+Sum(UnitSales)>0, Product), Product),Product, Customer)

Re: Include/Exclude Zero Values Dynamically

Kailash_Shaw — Mon, 29 Aug 2022 08:32:18 GMT

Thanks experts!

I have found another workaround that suited me better in this app.

I have unchecked the Include Zero Values in add on properties and added additional field to hide/unhide zero values with variable input. Here are the screenshots for reference.