https://community.qlik.com/t5/QlikView/Variables/m-p/1907360#M1217963 <P>I have a table box on qlikview showing the ordered quantities per each city on daily basis, i need to add expresion to calculate the variance between the quantity of the capital city vs the other cities in each day as below&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMG_20220320_212129.jpg" style="width: 406px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74918i9D5827FD03694068/image-size/medium?v=v2&amp;px=400" role="button" title="IMG_20220320_212129.jpg" alt="IMG_20220320_212129.jpg" /></span></P> <P> </P> <P>I created a variable = sum ({&lt;City={"City1 (Capital) "} &gt;} Quantity)</P> <P>And i added an expresion with the variable and another one to calculate the variance, but the variable value shows the total quantity of the capital city for all the days not per each day as below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMG_20220320_213400.jpg" style="width: 767px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74919i412B559B4289C02F/image-size/medium?v=v2&amp;px=400" role="button" title="IMG_20220320_213400.jpg" alt="IMG_20220320_213400.jpg" /></span></P> <P> any help please ?&nbsp;</P> Thu, 31 Mar 2022 06:11:26 GMT MahaMohamed 2022-03-31T06:11:26Z https://community.qlik.com/t5/QlikView/Variables/m-p/1907360#M1217963 <P>I have a table box on qlikview showing the ordered quantities per each city on daily basis, i need to add expresion to calculate the variance between the quantity of the capital city vs the other cities in each day as below&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMG_20220320_212129.jpg" style="width: 406px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74918i9D5827FD03694068/image-size/medium?v=v2&amp;px=400" role="button" title="IMG_20220320_212129.jpg" alt="IMG_20220320_212129.jpg" /></span></P> <P> </P> <P>I created a variable = sum ({&lt;City={"City1 (Capital) "} &gt;} Quantity)</P> <P>And i added an expresion with the variable and another one to calculate the variance, but the variable value shows the total quantity of the capital city for all the days not per each day as below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IMG_20220320_213400.jpg" style="width: 767px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74919i412B559B4289C02F/image-size/medium?v=v2&amp;px=400" role="button" title="IMG_20220320_213400.jpg" alt="IMG_20220320_213400.jpg" /></span></P> <P> any help please ?&nbsp;</P> Thu, 31 Mar 2022 06:11:26 GMT https://community.qlik.com/t5/QlikView/Variables/m-p/1907360#M1217963 MahaMohamed 2022-03-31T06:11:26Z