topic Re: Filter doesn't apply correct in Dashboard in App Development

Filter doesn't apply correct in Dashboard

mendes094 — Fri, 21 Mar 2025 19:14:12 GMT

Hello,

I do a dimension with the intention to create a filter on the panel.
=if(
Match(NM_NEGOCIO,'AA','BB','CC', 'DD')
and Match(CD_MARCA_PRODUTO,01, 02, 03), 'ALP',

if(NM_NEGOCIO = 'NE' and ABASTECIMENTO_COS > 0, 'ALP', 'NÃO ALP')
)

But when the User filter ALP on the panel, the filter doesn't respect this expression.

I need do an expression apply the conditional ABASTECIMENTO_COS > 0 just for NM_NEGOCIO = 'NE',
So when I choose ALP, the returns be something like this:

NM_NEGOCIO = 'AA' or 'BB' or 'CC' or 'DD',and

CD_MARCA_PRODUTO = 01 or 02 or 03, and

NM_NEGOCIO = 'NE' and ABASTECIMENTO_COS > 0 (this conditional is just for NM_NEGOCIO = 'NE').

Anybody can Help me.

Re: Filter doesn't apply correct in Dashboard

Chanty4u — Sat, 22 Mar 2025 16:54:21 GMT

Try this

If(

(Match(NM_NEGOCIO, 'AA', 'BB', 'CC', 'DD')

AND Match(CD_MARCA_PRODUTO, '01', '02', '03'))

(NM_NEGOCIO = 'NE' AND ABASTECIMENTO_COS > 0),

'ALP',

'NÃO ALP'

)

Re: Filter doesn't apply correct in Dashboard

mendes094 — Tue, 25 Mar 2025 17:17:36 GMT

Doesn't work, its strange, because when I export in Excel and apply the filter works.

But if I apply the filter before export doens't work rsrs

Re: Filter doesn't apply correct in Dashboard

Chanty4u — Tue, 25 Mar 2025 17:22:59 GMT

Please check the data types as you have numeric values

You can remove quotes around

If(

(Match(NM_NEGOCIO, 'AA', 'BB', 'CC', 'DD')

AND Match(CD_MARCA_PRODUTO, 01, 02, 03))

(NM_NEGOCIO = 'NE' AND ABASTECIMENTO_COS > 0),

'ALP',

'NÃO ALP'

)

And you can debug step by step in straight table that wil help you to identify where exactly causing the issue

Re: Filter doesn't apply correct in Dashboard

David_Friend — Tue, 25 Mar 2025 17:30:41 GMT

I've been told this is resolved now, can you confirm?

Re: Filter doesn't apply correct in Dashboard

mendes094 — Thu, 27 Mar 2025 13:10:17 GMT

The last step (NM_NEGOCIO = 'NE' AND ABASTECIMENTO_COS > 0) is the error,

It's not actually wrong, it's just that it applies the "ABASTECIMENTO_COS > 0" filter to the entire database, remembering that this error only occurs when filtering directly in the Qlik Sense table, if I export to Excel and filter it works normally.

Very strange,
I don't know if it's better to make this column in the script, but I'll face another challenge because they're from different tables.

Re: Filter doesn't apply correct in Dashboard

mendes094 — Thu, 27 Mar 2025 13:10:37 GMT

Doesn't work.