Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate sum of a coloumn

Hi all,

I have the expresion if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0) and i want to caluclate the sum of the counts produced by the expression.

Any help???

Thanks in advance.

3 Replies
Gysbert_Wassenaar

sum(if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0))

or if you're using a straight table set the total mode to sum of rows


talk is cheap, supply exceeds demand
Not applicable
Author

I tried setting the mode of sum rows in the table and i get the result. But how do i use this result to make other calculations????

Gysbert_Wassenaar

Then you'll have to use sum(total if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0))


talk is cheap, supply exceeds demand