Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Help

Hi,

I 'm not getting the result as expected.Can anyone help me on this.

Result should be Sum(A)/Sum(B) and Clomun1 <> 0

3 Replies
Not applicable
Author

Could you please provide a little more context?  Maybe a more detailed description or a sample qvw?

venkatg6759
Creator III
Creator III

if(Cloumn1<>'0',Sum(A)/Sum(B))

Not applicable
Author

sum({<Column1 -= {0}>}A)/sum({<Column1 -= {0}>}B)

This will give you sum of A divided by sum of B where column1 does not equal 0