topic conditional expression help in QlikView https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095671#M932354 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have attached a sample qvw.</P><P>It has branch wise sales and working days.</P><P>The first pivot table is showing correct days for a branch.</P><P></P><P>but the second pivot table is giving wrong working days as it is having customer numbers.</P><P></P><P>Please help me with the expression to show same working days in both the pivot tables.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z conditional expression help https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095671#M932354 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have attached a sample qvw.</P><P>It has branch wise sales and working days.</P><P>The first pivot table is showing correct days for a branch.</P><P></P><P>but the second pivot table is giving wrong working days as it is having customer numbers.</P><P></P><P>Please help me with the expression to show same working days in both the pivot tables.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095671#M932354 2020-11-25T16:16:04Z Re: conditional expression help https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095672#M932355 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=sum(<STRONG>TOTAL&lt;Branch&gt;</STRONG> WorkingDays)</P><P></P><P>in your second pivot table</P></BODY></HTML> Fri, 04 Mar 2016 19:27:47 GMT https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095672#M932355 swuehl 2016-03-04T19:27:47Z Re: conditional expression help https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095673#M932356 <HTML><HEAD></HEAD><BODY><P>thank u swuehl.</P></BODY></HTML> Fri, 04 Mar 2016 20:42:47 GMT https://community.qlik.com/t5/QlikView/conditional-expression-help/m-p/1095673#M932356 2016-03-04T20:42:47Z