Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

hide a measure but keep its result

Hello I'm working on a Table in Qlik Sense, in which there is a column named ACCOUNT and some of its values contain space i.e. " "
now I want to hide the ACCOUNTs where values = " "
I was able to do so by adding a simple measure: sum({<ACCOUNT-={" "}>} 1)
this is fine but I don't want users to see the results of this measure
so is there a way to hide this measure but keeping its result so that ACCOUNTs with values " " don't appear?

I tried to make a calculated dimension for ACCOUNT:  aggr(only({<ACCOUNT-={" "}>} ACCOUNT),ACCOUNT) but the response of the table is very slow

 

I can walk on water when it freezes
Labels (1)
2 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi @ali_hijazi ,

Which are your table dimensions and measures ?
What's the actual and expected result ?

ali_hijazi
Partner - Master II
Partner - Master II
Author

table has several dimensions
one of them is ACCOUNT

I can walk on water when it freezes