Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
tresB
Champion III
Champion III

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

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