topic Re: Re: To calculate Quantity based on Units in QlikView

To calculate Quantity based on Units

Sun, 12 Jan 2014 12:11:59 GMT

Hello Guys,

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

Sravan

Re: To calculate Quantity based on Units

jonathandienst — Sun, 12 Jan 2014 12:34:43 GMT

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,

Change

SET DecimalSep=',';

SET DecimalSep='.';

HTH

Jonathan

PS: you could use the number interpretation function rather than changing the environment, for example:

LOAD ...., Num#(Quantity, '#.#####', '.', ' ') As Quantity, ...

Re: To calculate Quantity based on Units

Sun, 12 Jan 2014 12:38:50 GMT

hi jonathan,

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?

Re: To calculate Quantity based on Units

maxgro — Sun, 12 Jan 2014 13:26:23 GMT

also replace this in your script

text(Quantity) as Quantity,

with

Quantity,

Regards

Re: Re: To calculate Quantity based on Units

Anonymous — Fri, 17 Jan 2014 18:44:30 GMT

you'll have to use Jonathan's snippet for Quantity and Factor.

See attached