Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
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!
Perhaps Qlik has recognized the values as numbers but as text. That could explain, why they can't be multiplied.
You could try making expressions that Sum the fields.
Hello Jfkinspari, as below pic indicated, i have tried with with various means of NUM(), Evaluate() etc, as red square circled expressions, but all failed, it gave the empty cells like red arrowed. what could be the reasons??
the original PUR_Currency_1 is like picture right side showed.
kindly please let me know if you have the solution. thanks
Just a tip, I'd keep using
Replace([PUR_Currency_1],'-','')
to remove the '-' in case there are text values that differ in length.
What does it say if you just do the following:
Num#(Replace([PUR_Currency_1],'-',''))