Simple count

[New-Qlik]

Hello Everyone ,

I have to count no of 'Bad' for product

Condition for Good bad is like :If(Cause Price = 'ZYZ', 'Good', 'Bad') , its same for rest of causes in table.

I want to generate last column ie "Total No of  causes" using existing causes column where its BAD

Product ID	Cause Price	Cause Description	Cause Owner	CauseMArket	Total No of causes
1	Good	Bad	Bad	Bad	3
2	Bad	Good	Good	Bad	2
3	Good	Bad	Good	Good	1
4	Good	Bad	Bad	Good	2

[Vegar · Accepted solution]

You can use rangesum() like this:

=-Rangesum(
[Cause Price] ='Bad',
[Cause Description]='Bad',
[CauseMArket] ='Bad',
[Cause Owner] ='Bad'
)

[Vegar]

If you rather want to use your Cause Price = 'ZYZ' logic you can do like this instead,

=-Rangesum(
[Cause Price] <> 'ZYZ',
[Cause Description] <> 'ZYZ',
[CauseMArket]  <> 'ZYZ',
[Cause Owner]  <> 'ZYZ'
)

[New-Qlik]

Thanks It worked. 

can you explain the reason for using '-' in front.

[Vegar]

The boolean check returns -1 if true(). By adding - in front turns it into positive number.