How to filter values?

[Vasiliy_Beshentsev]

Hello, everyone!

How to filter field values in expressions?

When i check some values in field SBU(ID agent field), for example, it nothing shows me, it no money shows (DEC is money field)

How to write expression that i will see only SBU's which got DEC's ?

[Gysbert_Wassenaar]

Can you post a small qlik sense app that demonstrates the problem?

[ahaahaaha]

Maybe so  Only ({<DEC = {">0"}>} SBU) ?

[Vasiliy_Beshentsev]

Doesn't work, tried this already.

[Vasiliy_Beshentsev]

So i dont want to see this agents in filter list

And see only this cool guys who got cash

And i want to make something in dimension expression to get this point

[ahaahaaha]

Set_expression will be necessary to write in each of all expression your table fields.

[MK9885]

What is the expression you using in Pivot Table?

And what field is used in filter?

Can you post a sample?