as below, i intend to multiply PUR_Price*PUR_Currency_1 and sum finally at KPI, however, the last column resulted in zero, and i looked at earlier posts in qlikview and also tried with following expressions, but all didn't work out on my qliksense, anyone can help ?? thanks!
Okay, so if we just assume only one unique value of both PUR_Price*PUR_Currency_1 is available per row, you should just be able to write the formula as : SUM(PUR_Price*PUR_Currency_1) or to be more precise: Sum(Only(PUR_Price)*only(PUR_Currency_1))
Hello, it might be not unique value, since it is for purchase data over the years, so it might be same mateiral be purchased at same price and exchange rate, however, the PUR_Order_Number, PUR_Order_Item, PUR_Material_Number are the 3 factors to decides its uniqueness of this row.
To debug I would suggest you create two new columns each displaying Only(PUR_Price) Only(PUR_Currency_1) At least one of those two expression must return "-" for a row in order to explain the behaviour.