Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sum of something with if conditon

i want sum of values

i have

compaNY NAME
AMOUNT
ABC10
BTY20
ATE10
ZYS50

I WANT THE SUM ON ABC BTY AND ATE WHICH IS 40 IN A BAR

THE FOLLOWING CODE:

Sum({$<COMPANY_NAME = {"A*","B*"}>}AMOUNT)

in bar chart but i am getting all the bar of company name starting from a and b

thanks in advance

10 Replies
Anonymous
Not applicable
Author

i wanted this in Qlik Sense the above one i tried now in qlikview it worked

thanks a lot buddy