Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @ali_hijazi ,
Which are your table dimensions and measures ?
What's the actual and expected result ?
table has several dimensions
one of them is ACCOUNT