Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about:
if(Max(TOTAL Match([Data category] & Status, 'AllApproved')), 'Approved', Status)
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Perhaps this
If([Data category]='All' and Status='Approved', 'Approved', Status)
How about:
if(Max(TOTAL Match([Data category] & Status, 'AllApproved')), 'Approved', Status)
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Wow, Rob! Thank you. This is exactly the solution I was looking for. I really appreciate your help!