Display in a table of Qlik Sense only values of Di... - Qlik Community

makis_zimianitis · ‎2025-02-13

BPiotrowski · ‎2025-02-13

Hi,

on your measure column set if like this

=if(sum(y+x)>5,sum(y+x),null())

and than in table properties add-ons -> way of handling data

uncheck null values

makis_zimianitis · ‎2025-02-13

thank you @BPiotrowski

It works fine.

If i have multiple columns in a table, i have to add in each of them the relevant expresions.
is there any other way to achive the same result , because reading in the community that" if statements " have impact in to performance i wondering if it's the best solution !!

BPiotrowski · ‎2025-02-13

So in this situation the only possible way I know would be preparing table in load script.

As I know it's the most efficient solution.

Display in a table of Qlik Sense only values of Dimension which a measure is bigger than a spesific value

General Question

Script and Expressions