Solved: Set Analysis - not equal to with multiple conditio... - Qlik Community

Report Inappropriate Content · ‎2012-07-02

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

MayilVahanan · ‎2012-07-02

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

MayilVahanan · ‎2012-07-02

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.

Report Inappropriate Content · ‎2012-07-02

Perfect

thanks

James Makepeace

MI Analyst

Southern Rock Insurance

Tel: 01454635844

v_iyyappan · ‎2012-07-02

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.

Set Analysis - not equal to with multiple conditions