topic how to use sum function on virtual field? in QlikView

how to use sum function on virtual field?

Fri, 07 Dec 2012 05:20:56 GMT

hi Everyone

please help me with this....

In a chart properties of pivote chart , i have two expressions labelled ie... [no. of quantity] and [new_price]

iI want to get another expression which is the Product of the above two. and it should also show the Subtotal value .

i have written

sum([no. of quantity]*[new_price] ))

but the summation of the product is not working althogh I am getting the product.

thanks in advance

Re: how to use sum function on virtual field?

Fri, 07 Dec 2012 06:45:18 GMT

Hi,

What do you mean by "I am getting the product"? I have noticed that your fomula exceeds 1 closing parenthesis. Maybe it will fix your problem.

Regards,

Janzen

Re: how to use sum function on virtual field?

Fri, 07 Dec 2012 09:03:55 GMT

sum([no. of quantity]*[new_price] )

by mistake i wrote that , but it does not work

Re: how to use sum function on virtual field?

jonathandienst — Fri, 07 Dec 2012 09:12:42 GMT

Although you can use named columns or Column() to refer to other columns in a table or chart in your expressions, unfortunately you cannot use aggregation functions (like Sum, Avg, Min).

So you will need to substitute the expressions for [no. of quantity] and [new_price] to perform this calculation

Regards

Jonathan