topic Re: Set Analysis Help in QlikView

Set Analysis Help

Tue, 10 Jun 2014 18:54:02 GMT

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

Tue, 10 Jun 2014 18:55:29 GMT

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

venkatg6759 — Tue, 10 Jun 2014 18:56:10 GMT

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

Tue, 10 Jun 2014 18:56:39 GMT

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