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!
Could you perhaps give us a sample app?
You can't upload .qvf files, but perhaps you can upload an excel with sample data and a docx with measures. It's a very roundabout way, but I don't think the new community platform leaves us any other choice.
The sample app would make it easier for us to help you, as well as being faster instead of suggesting possible solutions again and again.
It seems extremely weird to me that it would just turn to 0 because of the changed format honestly.
Okay, please find the source data i just exported from same app, with first 5 column are the original data extracted. kindly please let me know if you have any solution, thanks!
Hey
I just uploaded the data from the Excel into Qlik Sense, without any transformations.
And then made this table:
As you can see, I have no issue performing the multiply and getting the comma as decimal seperator.
These are my predefined format variables (default in script):
SET ThousandSep='.'; SET DecimalSep=','; SET MoneyThousandSep='.'; SET MoneyDecimalSep=','; SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
The money variables aren't important, unless you want to display the values as currency.
Glad your issue got solved.
For future reference, it's best to make sure your fields have the same format by applying the Num(), Date(),... functions in the script. In turn, you'll often avoid issues like this.
Please mark the appropiate answer as correct, or post the solution to mark as correct if you solved it yourself. Posts that helped you in coming up with the solution can be marked helpful.
Regards,
Tim P.
Hello , for sure will mark up the appropriate one as accepted solution, but still regarding this same topic, i am trying to use KPI to show up the sum of multiplied value with currency in RMB only. the below expression is the formula for YTD value, but even i add into PUR_Currency={'RMB'}, there is no change in the numbers, why?