topic Re: countif values within table in QlikView

countif values within table

Mon, 02 May 2016 14:45:03 GMT

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

i want to use it on straight / pivot table

TNX

Ariel

sunny_talwar — Mon, 02 May 2016 15:53:43 GMT

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

Tue, 03 May 2016 07:13:45 GMT

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