hide a measure but keep its result

ali_hijazi — Tue, 25 Oct 2022 07:38:27 GMT

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

Re: hide a measure but keep its result

agigliotti — Tue, 25 Oct 2022 07:51:43 GMT

Hi @ali_hijazi ,

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

Re: hide a measure but keep its result

ali_hijazi — Tue, 25 Oct 2022 08:30:05 GMT

table has several dimensions
one of them is ACCOUNT

topic hide a measure but keep its result in App Development

hide a measure but keep its result

Re: hide a measure but keep its result

Re: hide a measure but keep its result