topic Re: Dimensions not filtering with variable in App Development

Dimensions not filtering with variable

jalanhart — Fri, 14 Feb 2025 00:48:44 GMT

Hello,

I have a variable that sums a field filtered down by certain dimensions. Currently I have a measure in the table which uses a pick(match) that applies set analysis measures based on the variable button selected.

Example here Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)

The issue is that when this button is selected, it still shows other codes with a 0 in the measure column. I do not want remove the zeros through the data handling because that could filter too much.

The table should only show rows with OESHIP and SHIPTRAN but it's showing more than that.

How do I get those rows to NOT show up based on a variable selection?

Re: Dimensions not filtering with variable

Anil_Babu_Samineni — Fri, 14 Feb 2025 08:08:29 GMT

Perhaps try this?

Sum({<TRANSACTION_CODE = P({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} TRANSACTION_CODE)>} QUANTITY)

Sum({<TRANSACTION_CODE = {"=Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)>=0"}>} QUANTITY)

Re: Dimensions not filtering with variable

morgankejerhag — Sat, 15 Feb 2025 09:07:11 GMT

Go to the chart settings -> Add ons -> Data handling -> untick Include zero values

Re: Dimensions not filtering with variable

Chanty4u — Sun, 16 Feb 2025 14:08:11 GMT

Try this

=If(Match(TRANSACTION_CODE, 'OESHIP', 'SHIPTRAN'),

Sum({<TRANSACTION_CODE = {'OESHIP','SHIPTRAN'}>} QUANTITY)

)