Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
GMadd
Contributor
Contributor

Power BI Switch command what is the Equivalent in Qlik?

New to Qlik and need to determine if a shipment was shipped late based on other columns in my data table. 

The table has the date the delivery should ship (planned ship date) and when it did ship Act. Gds. Mvment Date). Obviously if the actual goods movement date is after the planned ship date it is late but there is more to it than that. I want to assign each delivery a "Category" based on the criteria I outline.  In Power BI I created a calculated column below and I am not sure Qlik is set up the same way. Can you help me figure out how to handle this?

Category =
SWITCH(
    TRUE(),
    'Delivery Tracking'[Act. Gds Mvmnt Date]<='Delivery Tracking'[Planned Ship Date], "On-Time",
    'Delivery Tracking'[Delay Reason Code - Header]= 13, "Customer Delay/System Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 356, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 01, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 02, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 03, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 04, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 05, "Carrier Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 06, "Back Order",
      'Delivery Tracking'[Delay Reason Code - Header]= 07, "Carrier Assignment Delay",
      'Delivery Tracking'[Delay Reason Code - Header]= 08, "Late",
      'Delivery Tracking'[Delay Reason Code - Header]= 09, "Late Carrier Assignment",
      'Delivery Tracking'[Delay Reason Code - Header]= 10, "Late Order Entry",
      'Delivery Tracking'[Delay Reason Code - Header]= 11, "Warehouse Inventory Issue",
      'Delivery Tracking'[Delay Reason Code - Header]= 12, "Material Quality Issue",
    'Delivery Tracking'[Act. Gds Mvmnt Date]> 'Delivery Tracking'[Planned Ship Date] && 'Delivery Tracking'[Late_CPUX]= "" && 'Delivery Tracking'[Pick-Up App?]= "No" && 'Delivery Tracking'[Credit Hold]= "VERKBELEG", "Credit Hold",
    'Delivery Tracking'[Changed Mode] = "Yes" && 'Delivery Tracking'[Act. Gds Mvmnt Date]>'Delivery Tracking'[Planned Ship Date], "Changed Mode",
    'Delivery Tracking'[Created On]>='Delivery Tracking'[Planned Ship Date], "Back Order",
    'Delivery Tracking'[Pick-Up App?]= "Yes", "P-Up Appt After",
    'Delivery Tracking'[Late_CPUX]= "Late CPUX", "Late CPUX",
    'Delivery Tracking'[Act. Gds Mvmnt Date]>'Delivery Tracking'[Planned Ship Date], "Late"
)
Labels (3)
1 Reply
anat
Master
Master

you can try same switch in qliksense also

https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptControlSt...

or else use pick and match