topic Re: Values are mismatching in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Values-are-mismatching-in-Pivot-Table/m-p/45375#M7583 <HTML><HEAD></HEAD><BODY><P>Can you share a sample file to look into? </P></BODY></HTML> Wed, 02 May 2018 16:13:47 GMT vishsaggi 2018-05-02T16:13:47Z Values are mismatching in Pivot Table https://community.qlik.com/t5/QlikView/Values-are-mismatching-in-Pivot-Table/m-p/45374#M7582 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>When I select March Month in List Box, the value is coming perfect for March month whereas select Apr month it is showing as wrong</P><P></P><P>Below is screenshot for your reference.</P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/201293_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P><P>I want to see the value (130618) for match while selecting any months. Kindly please help me.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201292_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>The correct value is 130618.</P><P></P><P>Expression:</P><P></P><P>(sum({$&lt;Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},Calendar_Month = {'&lt;=$(=max(Calendar_Month))'},Day_Number_In_Month = {'&lt;=$(=max(Day_Number_In_Month))'},Day_of_Week=&gt;}Sales_Value))/1000</P></BODY></HTML> Wed, 02 May 2018 16:02:00 GMT https://community.qlik.com/t5/QlikView/Values-are-mismatching-in-Pivot-Table/m-p/45374#M7582 dineshm030 2018-05-02T16:02:00Z Re: Values are mismatching in Pivot Table https://community.qlik.com/t5/QlikView/Values-are-mismatching-in-Pivot-Table/m-p/45375#M7583 <HTML><HEAD></HEAD><BODY><P>Can you share a sample file to look into? </P></BODY></HTML> Wed, 02 May 2018 16:13:47 GMT https://community.qlik.com/t5/QlikView/Values-are-mismatching-in-Pivot-Table/m-p/45375#M7583 vishsaggi 2018-05-02T16:13:47Z