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

countif values within table

Hi

i would like to know if there's a way to count values in different cells

like this Example in excel

COUNTIF(I6:M6, 2)*5+COUNTIF(I6:M6, 1)*1

if there's a value '2' in range count it and multiple by 5

if there's a value '1' in range count it and multiple by 1

ABCDEScore
000216
000216
001026
010026
021006
002005
002005
000205

i want to use it on straight / pivot table

TNX

Ariel

2 Replies
sunny_talwar

Not entirely sure how your data looks, but may be like attached

Not applicable
Author

Thanks Sunny

unfortunately i working now with personal addition so i can't open the file

can you please write how you solved it

my data is on  straight table i have 4 dimensions and the expressions is looks like the table above

i want to add another column (SCORE)  that calculate according to the values of the expressions in every row

COUNTIF(I6:M6, 2)*5+COUNTIF(I6:M6, 1)*1


thanks again for your help