Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum value field

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

3 Replies
PradeepReddy
Specialist II
Specialist II

can you share sample application?

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rajeshforqlikvi
Creator
Creator

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.