topic Re: Invert selection in Set Analysis in QlikView

Invert selection in Set Analysis

Wed, 30 Jul 2014 12:57:05 GMT

Hi,

to restrict certain clients I use Set Analysis:

Sum ({$<Client={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

what the correct syntax to invert selection? ie exclude clients 'ABCDE LTD', 'QWERTY LTD', 'Others LTD'?

Regards,

Oleg

Wed, 30 Jul 2014 12:58:18 GMT

Sum ({$<Client-={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Also take a look at this thread as it outline the different operators you can use

hope that helps

Joe

Wed, 30 Jul 2014 12:59:02 GMT

Hi,

Did you tried

Sum ({$<Client-={'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Thanks

MK_QSL — Wed, 30 Jul 2014 13:01:11 GMT

Sum ({$<Client -= {'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

aveeeeeee7en — Wed, 30 Jul 2014 13:08:25 GMT

Try this:

Sum ({$<Client={'*'}-{'ABCDE LTD', 'QWERTY LTD', 'Others LTD'}>} Shipment.Sum)

Regards

Aviral Nag