Combining values in load script

[Anonymous]

Hi guys,

in my loading script I want to create a field which measures our orders in portfolio.

Therefore, I want to distinguish our confirmed orders from our orders in process.

The orders in proces can be recognized by their "Extra Status".

To combine these different statuses, I tried the following script which didn't worked as I hoped for.

Concatenate

Load *,

"Outstanding Quantity" * [Unit Price] - [Invoice Discount Amount] - [Invoice Line Discount Amount] as [Nett Amount Order Portfolio],

'Order Portfolio' as [Scenario]

Resident Orders

WHERE "Extra Status" = 5 AND Status = 1;

Concatenate

Load *,

"Outstanding Quantity" * [Unit Price] - [Invoice Discount Amount] - [Invoice Line Discount Amount] as [In Process Order Portfolio],

'Order in process Portfolio' as [Scenario]

Resident Orders

WHERE "Extra Status" = ('1,4,6,7,8') AND Status = 1;

I'm sure you guys can help me out with this one!:)

Thanks a lot!

Mike

[vinieme12 · Accepted solution]

again use Match()

WHERE Match(Extra Status,'1','4','6','7','8') AND Status = 1;

[Anonymous]

Thanks Vineeth! So Match is helping me out for every combination or exclution I want to make?:)

[vinieme12]

yep Match() or Wildmatch() is most frequently used it's the qlikview equivalent of Like statement in SQL

You can read more about them here

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ConditionalFunctions/m...