Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RobertB07
Contributor II
Contributor II

Set analysis to hide rows

I found the following expression in a table:

=if(count({<[Credit/Debit Indicator]={'DBIT'}>} Account)=1, Account)

For what is understand it seems to contain a set analysis to show the Account if it meets the condition. But when i try to recplicate it in the expression editor it says 'OK' but the table says 'invalid dimension. 

=if(count({<[objectClass]={'domain'}>}PwdSettingsFilter)=1, PwdSettingsFilter)

What am i doing wrong? Can set analysis be used to hide row or values from a table?

1 Reply
tresesco
MVP
MVP

If you want to use this expression as dimension, try like:

=Aggr(if(count({<[objectClass]={'domain'}>}PwdSettingsFilter)=1, PwdSettingsFilter) , PwdSettingsFilter)