Discussion Board for collaboration on QlikView Scripting.
Looks very easy but I dont get it. Seems to be not my day. I just wanted to get the values of Quantity_in_kWh in the following example.
Hope someone can help. See the attachment.
Thanks in Advance
Your environment setting is for , (comma) as the decimal separator, but your data uses a . (period); so QV does not recognise your values as numbers,
PS: you could use the number interpretation function rather than changing the environment, for example:
LOAD ...., Num#(Quantity, '#.#####', '.', ' ') As Quantity, ...
that does not solve the problem. I think I am making some silly mistake or overlooking something. why cant I multiply the Quantity and unit to get the Quantity_in_kWh?
also replace this in your script
text(Quantity) as Quantity,
you'll have to use Jonathan's snippet for Quantity and Factor.