Matt
Matt

Reputation: 15061

Qlikview use IN rather than = in a variable in an expression

I have a variable in an expression that SELECTS bottles.

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

I would like it to be able to select where RCPT equals bottle OR laptop.

Upvotes: 1

Views: 72

Answers (1)

Matt
Matt

Reputation: 15061

The IN values need to be contained in {'value1', 'value2', 'value3'....etc} but still using RCPT =

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

Upvotes: 1

Related Questions