Hello All,
I have a file with Item, cust num,status and effective date this will be joining to shipments file with Item , cust num and ship date so I created a item unique itemcust key
now I want to create a Result field with closeout & exclcloseout as values depending on multiple conditions
- If a Item column has value ALL all items to that cust are closeout
- if a item has status mentioned as closeout and exclcloseout starting from that effective date they are closeout and exclcoseout status respectively
- if a item has no status mentioned they all exclcloseout
![Capture.PNG Capture.PNG](https://community.qlik.com/t5/image/serverpage/image-id/8265iEEE41EB6C4EC3F29/image-dimensions/7x1?v=v2)
![Capture.PNG Capture.PNG](https://community.qlik.com/t5/image/serverpage/image-id/8276i8EB7D96974581668/image-size/medium?v=v2&px=400)
attached files
please help
thanks,
D