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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - not equal to with multiple conditions

Hi

Why does this set analysis expression doesn't work? It still includes some eCar / Asda OE data, even though i am specifically stating ignore it.

 

Min({$<[Insurer]-={'Asda OE, eCar'}>} [Premium])

 

Your help is much appreciated

James

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan
MVP
MVP

Hi,

Try this,

    

     =Min({$<[Insurer]-={'Asda OE', 'eCar'}>} [Premium])

    Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan
MVP
MVP

Hi,

Try this,

    

     =Min({$<[Insurer]-={'Asda OE', 'eCar'}>} [Premium])

    Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Perfect

thanks

James Makepeace

MI Analyst

Southern Rock Insurance

Tel: 01454635844

v_iyyappan
Specialist
Specialist

Hi,

   

      If u got correct answer means please provide mark him. it wil encourage for us and also every one easy to know the correct post and get the knowledge.

Regards,

Iyyappan.