Calculated field based first and second column

[aruneshgupta]

Hi All,

I'm seeking your help writing a logic in Qlik chart, not in script.

I require a calculated field named 'Calculated_Status,' where the logic dictates that if the 'Data Category' is 'All' and the Status is 'Approved,' then every row should display the status as 'Approved.' Otherwise, it should retain the original 'Status' values. Please find examples for both scenarios below.

Data category	Status	Calculated_Status
All	Approved	Approved
Sheet1	Open	Approved
Sheet2	Closed	Approved
Sheet3	Approved	Approved
Sheet4	Open	Approved
Sheet5	Open	Approved

or

Data category	Status	Calculated_Status
All sheets	Open	Open
Sheet1	Open	Open
Sheet2	Closed	Closed
Sheet3	Approved	Approved
Sheet4	Open	Open
Sheet5	Open	Open

Thanks in advance!

Best Regards,

Arunesh

[Anil_Babu_Samineni]

@aruneshgupta 

Perhaps this

If([Data category]='All' and Status='Approved', 'Approved', Status)

[rwunderlich · Accepted solution]

How about:

if(Max(TOTAL Match([Data category] & Status, 'AllApproved')), 'Approved', Status)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[aruneshgupta]

Wow, Rob! Thank you. This is exactly the solution I was looking for. I really appreciate your help!