return the value that matched the category.

[Anonymous]

Hi Everyone,

I'm really new in Qlik. would like to return the data with the below conditions.

I have attached the data with 2 tabs:

1. sample data

2. desired result

Condition:

Return CLI for 1st Participant "customer" Purpose INBOUND Direction

Return CLI for "customer" Participant Purpose OUTBOUND Direction

luismadriz‌ thanks!

[luismadriz]

Of course Isabel, no problems at all!

I think on the other post you had there is a recommendation on how to modify the script but any number field that reflects the load order as you want should be fine.

Cheers,

Luis

[Anonymous]

yeah, i just don't have access on the back-end.

I have already asked the developer to do the load order script

Super thanks genius!

[Anonymous]

Hi Luis,

I'll create a new discussion on this again. some categories changed. I'll tag you.

[luismadriz]

No problem, please close this one by marking Correct the last one I sent with the sorting using the available fields

Cheers,

Luis