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!
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.
The measure that @jfkinspari suggested should still work.
On top of that, having 3 values decide on the uniqueness makes it less likely there will be double values.
Please try
SUM(Only(PUR_Price)*Only(PUR_Currency_1))
Regards,
Tim P.
Hello, it seems strange, with both only(), it works will as below illustrated, same as well with Agg(), but both failed in multipling these two fields. what is the cause?!?