topic Re: How to get the total in the expression ? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-total-in-the-expression/m-p/1260432#M859904 <HTML><HEAD></HEAD><BODY><P>Just remove the IF conditional part from your expression.</P><P></P><P>=<SPAN style="text-decoration: line-through;">if(distributor='ASPEN',</SPAN>sum({&lt;[plant_code]={'TEX','IFG','STX'}&gt;}$(vMeasure))<SPAN style="text-decoration: line-through;">,0)</SPAN></P></BODY></HTML> Tue, 17 Jan 2017 09:54:28 GMT tresB 2017-01-17T09:54:28Z How to get the total in the expression ? https://community.qlik.com/t5/QlikView/How-to-get-the-total-in-the-expression/m-p/1260431#M859903 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P></P><P>Please see the first column "Export Only - Net Stock Available" is not having sum in the above.</P><P><IMG __jive_id="149698" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149698_Capture.PNG" style="height: 449px; width: 620px;" /></P><P></P><P></P><P>But when I am select distributor as 'ASPEN' the total sum is showing.</P><P></P><P><IMG __jive_id="149711" alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/149711_Capture1.PNG" style="height: 474px; width: 620px;" /></P><P></P><P>My Requirement is that , the model should show the total even if I don't select the distributor in filter.</P><P><SPAN style="font-size: 13.3333px;">I have attached the sample model.</SPAN></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-total-in-the-expression/m-p/1260431#M859903 suvechha_b 2020-11-25T16:16:04Z Re: How to get the total in the expression ? https://community.qlik.com/t5/QlikView/How-to-get-the-total-in-the-expression/m-p/1260432#M859904 <HTML><HEAD></HEAD><BODY><P>Just remove the IF conditional part from your expression.</P><P></P><P>=<SPAN style="text-decoration: line-through;">if(distributor='ASPEN',</SPAN>sum({&lt;[plant_code]={'TEX','IFG','STX'}&gt;}$(vMeasure))<SPAN style="text-decoration: line-through;">,0)</SPAN></P></BODY></HTML> Tue, 17 Jan 2017 09:54:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-total-in-the-expression/m-p/1260432#M859904 tresB 2017-01-17T09:54:28Z