topic Re: sum value field in QlikView

sum value field

Tue, 26 Jan 2016 15:41:17 GMT

Hi,

I have some values and within a table.

I want to make a chart with a column per value in valuename I guess it can be doen with expressions. How do I sum a value field with expression Commission invoice in ValueName.

Commission invoice | Commision rebate | Commission Total
_________________ |________________ |_________________

1 | 10 | 14

2 | 12 | 14

3 | 14 | 14

Re: sum value field

PradeepReddy — Wed, 27 Jan 2016 05:31:11 GMT

can you share sample application?

Re: sum value field

jonathandienst — Wed, 27 Jan 2016 05:39:23 GMT

It can, but what is the actual fieldname or expression associated with Commission|Invoice?

If you post your qvw or a representative sample, you will get more specific and more accurate help.

Re: sum value field

rajeshforqlikvi — Wed, 27 Jan 2016 05:42:52 GMT

Hi,

you can do this by set analysis or if condition like below:

By If condition:

If(valueName ='Commission invoice ', sum(valueName ),

if(valueName ='Commision rebate',sum(valueName ),

if(valueName ='Commission Total',sum(valueName ))))

By set Analysis:

sum(<valueName ={'Commission invoice '}>valueName ) for this take a list box and write this exp in the expression in list box same way for all just check the syntax properly.