Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
2 Replies

Re: countif values within table

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

Not applicable

Re: countif values within table

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


Community Browser