Hello Jfkinspari, how to make it exactly? i just tried by adding two measures again like Sum(PUR_Price), it returns numbers. with Sum(PUR_Currency_1), it returns 0, so PUR_Currency_1 could be text instead of numbers ? if yes, how to correct?
Okay, I think you are closing in on the real issue. PUR_Currency_1 is recognized as text, so Qlik can Sum it, and can't multiply using the field. You need to convert the field, so Qlik think it's a number. How you convert it depends on you are loading data into Qlik Sense using the Data Load Editor or Data Manager. Look for how to use the Num() function.
thanks, however, Is it possible to change the format of PUR_Currency_1 in expression instead? otherwise i have to try when i can connect and loading with source data. but during previous data loading, as there was dash behind numbers in certain fields of PUR_Currency_1, so i had did following during load: Replace([PUR_Currency_1],'-','') as [PUR_Currency_1], but didn't format the field into numbers.
Reading some previous posts, it seems that EVALUATE() has to be used together with NUM. Will try tomorrow... LOAD TEXT_NUMBER, NUM(TEXT_NUMBER) AS NUMVLN, EVALUATE(TEXT_NUMBER) AS EVLN , num( EVALUATE(TEXT)_NUMBER),'#0') AS EVLN2
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