I’m working to create a KPI object, on qlik sense that only shows the total in a dashboard. On the attachment I need to calculated these two scenario one below. Need help with expression to hard code
1) if these material numbers equal to these quantities should equal to one rack
If quantity of material X equals amount x and some up with these other material and quantity then count it as 1 rack with the total KW .