topic Re: Use IN rather than = in a variable in QlikView

Use IN rather than = in a variable

matthewp — Mon, 01 Feb 2016 10:16:22 GMT

I have a variable that SELECTS bottles.

sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle'}>}[Amount]*-1)

I would like it to be able to select where it = bottle OR laptop

Re: Use IN rather than = in a variable

sunny_talwar — Mon, 01 Feb 2016 10:55:32 GMT

May be this:

Sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] = {'Bottle', 'Laptop'}>}[Amount]*-1)

Re: Use IN rather than = in a variable

tresB — Mon, 01 Feb 2016 10:56:44 GMT

Try:

sum({$<[PCC] ={"$(=concat([MCC],'","'))"},[RCPT] ={'Bottle' , 'laptop'}>}[Amount]*-1)

Re: Use IN rather than = in a variable

Peter_Cammaert — Mon, 01 Feb 2016 10:58:33 GMT

Don't be mistaken. The equal sign in a set modifier is an assignment operator, NOT a comparison operator. The values between curly braces get assigned to the field on the left as a sort of temporary selection. They do not compare to anything.

And just as with listbox selections, you select value1 or value2 or valueN in field RCPT...

Peter