topic Set analysis problem in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178021#M45377 <HTML><HEAD></HEAD><BODY><P>this is the excel file</P></BODY></HTML> Tue, 09 Nov 2010 12:17:21 GMT 2010-11-09T12:17:21Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178020#M45376 <HTML><HEAD></HEAD><BODY><P>I thought this is simple but somehow i'm doing something wrong!</P><P>i attached my QVW and a excel file. The excel is what i'm trying to get.</P></BODY></HTML> Tue, 09 Nov 2010 12:16:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178020#M45376 2010-11-09T12:16:39Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178021#M45377 <HTML><HEAD></HEAD><BODY><P>this is the excel file</P></BODY></HTML> Tue, 09 Nov 2010 12:17:21 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178021#M45377 2010-11-09T12:17:21Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178022#M45378 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try this</P><P></P><P></P><P>=</P><P><B>Sum</B>(<B>Real</B>)/<B>sum</B>({$&lt;<B>Periode</B>={'1'}&gt;}<B>total</B> <B>Norm</B>)</P><P>Regards</P><P>Benoît</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 09 Nov 2010 12:35:34 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178022#M45378 2010-11-09T12:35:34Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178023#M45379 <HTML><HEAD></HEAD><BODY><P>Change the expression:</P><P>=Sum(Real)/TOP(TOTAL sum(Norm))</P></BODY></HTML> Tue, 09 Nov 2010 12:56:49 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178023#M45379 2010-11-09T12:56:49Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178024#M45380 <HTML><HEAD></HEAD><BODY><P>thnx both suggestions work, but i go for the last solution!</P></BODY></HTML> Tue, 09 Nov 2010 13:13:43 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/178024#M45380 2010-11-09T13:13:43Z