Discussion board where members can get started with QlikView.
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
Go to Solution.
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
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.
sum([no. of quantity]*[new_price] )
by mistake i wrote that , but it does not work