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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

unable to use <> in formula

Hi,

i am using the following formula but would like to add "ProdType<>'200021'".  I don't seem to be able to use "<>".  what should i be using?

ok:-

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1


when i add "ProdType<>{'200021'}>" the formula doesn't work. 

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'},ProdType<>{'200021'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1
 

Cheers,

Lc

11 Replies
tamilarasu
Champion
Champion

Hi,

Try like below,

=Count(DISTINCT {<IsMember={'Yes'},[ProdTypeCode]={'Membership'},ProdType= {'*'}-{'200021'}>}[AccountNo]&[AccountName]&[ProductClassificationSummary])-1

engishfaque
Specialist III
Specialist III

Dear Laura,

Please share your sample data.

Kind regards,

Ishfaque Ahmed