Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi Neil,
I should advice a script solution on this on.
In the Script add a left join to the Order-Menu-Items.
LEFT JOIN ('Order Items') LOAD
Order-Menu-Items,
Cost
FROM Menu;
If you can't edit the script then you could calculate the correct number with this expression (assuming that there is only 1 cost value per Order-Menu-Item). :
COUNT(Order-Menu-Items) * Cost.