topic Re: expression condition in QlikView https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102979#M915660 <HTML><HEAD></HEAD><BODY><P>thank u so much sunny</P></BODY></HTML> Thu, 19 May 2016 11:49:18 GMT 2016-05-19T11:49:18Z expression condition https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102976#M915657 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have attached a sample&nbsp; qvw &amp; an excel sheet associated to it.</P><P></P><P>In the qvw, there are three tables and one of them is the required output which i m struggling to get.</P><P></P><P></P><P><IMG alt="Required.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125026_Required.JPG" style="height: auto;" /></P><P></P><P>Please help me with the expression to get the required values</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102976#M915657 2020-11-25T16:16:04Z Re: expression condition https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102977#M915658 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(SA*SRDAYS)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Sum(Aggr(Sum(SA) *Sum(SRDAYS), RSMNAME, BRCODE))</STRONG></P></BODY></HTML> Thu, 19 May 2016 11:16:15 GMT https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102977#M915658 sunny_talwar 2016-05-19T11:16:15Z Re: expression condition https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102978#M915659 <HTML><HEAD></HEAD><BODY><P>or: <SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">SA</SPAN><SPAN style="font-size: 8pt;">*</SPAN><SPAN style="color: #800000; font-size: 8pt;">SRDAYS</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">BRCODE</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Thu, 19 May 2016 11:21:24 GMT https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102978#M915659 stabben23 2016-05-19T11:21:24Z Re: expression condition https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102979#M915660 <HTML><HEAD></HEAD><BODY><P>thank u so much sunny</P></BODY></HTML> Thu, 19 May 2016 11:49:18 GMT https://community.qlik.com/t5/QlikView/expression-condition/m-p/1102979#M915660 2016-05-19T11:49:18Z