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
