Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
makis_zimianitis
Contributor
Contributor
‎2025-02-13 05:30 AM

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

 

 

 
Labels (2)
Labels
231 Views
3 Replies
BPiotrowski
Partner - Contributor III
Partner - Contributor III
‎2025-02-13 07:06 AM

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

 

 
206 Views
0 Likes
makis_zimianitis
Contributor
Contributor
‎2025-02-13 08:24 AM
Author

In response to BPiotrowski

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 !!

 

 
190 Views
0 Likes
BPiotrowski
Partner - Contributor III
Partner - Contributor III
‎2025-02-13 08:34 AM

In response to makis_zimianitis

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.

 

 

 

 
188 Views
0 Likes