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!
If case below doesn't work, it would perhaps be easier if you uploaded a sample app 🙂
Try
Num(Num#(Replace([PUR_Currency_1],'-',''),'#,####',',','.')) AS [PUR_Currency_1]
Dear ,
i used following to make it now, but the looking of decimal sepator are different compared with orignial version, one is dot, another is comma, seeing below, how to make them uniform?
Num(Num#([PUR_Currency_1], '#,####-', '.', ',')/10000,'#,####') AS [PUR_Currency_1],
No I wasn't aware of any problems uploading .qvf files, but a solution is to zip the file before uploading
You can also look into the num#() and num() to understand how it interprets and format numbers in regards to comma and thousand seperator
That solution won't work either. Or it didn't work for me yesterday at least.
@Vince_CH
The difference between num#() and num() is the following:
Num# is used to change, if possible, a string to a number. The input is like (yournumberastext,'format of how you want your number','decimal seperator','thousand seperator')
Num works the same way as Num#, but takes a number as input, not a string.
The only field you need to have though, is:
For Num# you need a number as a string
For Num you need a number.
If you only use those parameters in the function, the format and seperators will go to default and should match the values showing in your application.
Regards,
Tim P.
What does it give if you try the following:
Num#(Replace([PUR_Currency_1],'-',''))
This should default to the format of your app (the one that's set on the very first page of the script, all the variables being SET).