topic Re: Help with set analysis formula in QlikView https://community.qlik.com/t5/QlikView/Help-with-set-analysis-formula/m-p/1202018#M874784 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>sum(if(ProjectPlanning_PercentageGereed &lt; '100',ProjectPlanning_Uren)) / count(total &lt;ProjectPlanningFase_ID&gt; distinct if(ProjectPlanning_PercentageGereed &lt; '100',Planning_JaarWeek))</P></BODY></HTML> Mon, 31 Oct 2016 16:59:34 GMT Gysbert_Wassenaar 2016-10-31T16:59:34Z Help with set analysis formula https://community.qlik.com/t5/QlikView/Help-with-set-analysis-formula/m-p/1202017#M874783 <HTML><HEAD></HEAD><BODY><P>Can someone help me with the formula. In a pivot table i have a dimension Year week.</P><P></P><P>Now i like to divide my expression with the count of values for that dimension. I enclosed an example.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-formula/m-p/1202017#M874783 francisvandergr 2020-11-25T16:16:04Z Re: Help with set analysis formula https://community.qlik.com/t5/QlikView/Help-with-set-analysis-formula/m-p/1202018#M874784 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>sum(if(ProjectPlanning_PercentageGereed &lt; '100',ProjectPlanning_Uren)) / count(total &lt;ProjectPlanningFase_ID&gt; distinct if(ProjectPlanning_PercentageGereed &lt; '100',Planning_JaarWeek))</P></BODY></HTML> Mon, 31 Oct 2016 16:59:34 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-formula/m-p/1202018#M874784 Gysbert_Wassenaar 2016-10-31T16:59:34Z