topic Re: Help With Expression in QlikView https://community.qlik.com/t5/QlikView/Help-With-Expression/m-p/1009001#M958889 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Your expression doesn't contain an aggregation function so try this first:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum(</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[WIS - Curing Bin] -</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">/ [WIS - Curing Bin]</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">* 100</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</P></BODY></HTML> Thu, 05 Nov 2015 14:59:09 GMT Gysbert_Wassenaar 2015-11-05T14:59:09Z Help With Expression https://community.qlik.com/t5/QlikView/Help-With-Expression/m-p/1009000#M958888 <HTML><HEAD></HEAD><BODY><P>Hi Guy's</P><P></P><P>I am trying to create a straight table with results in the expression total at the top. I do not know where to put aggr or my sum values for it to display. Below is the calculation</P><P></P><P>[WIS - Curing Bin] -</P><P>([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)</P><P>/ [WIS - Curing Bin]</P><P>* 100</P><P></P><P>Thank you in advance</P></BODY></HTML> Mon, 02 Nov 2015 12:31:28 GMT https://community.qlik.com/t5/QlikView/Help-With-Expression/m-p/1009000#M958888 2015-11-02T12:31:28Z Re: Help With Expression https://community.qlik.com/t5/QlikView/Help-With-Expression/m-p/1009001#M958889 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Your expression doesn't contain an aggregation function so try this first:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum(</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[WIS - Curing Bin] -</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">([WIS - Curing Bin]/[Sample Wis Mass])*([Sample Dis Mass]*(100-[Sample DIS Moisture]))/(100-1.5)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">/ [WIS - Curing Bin]</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">* 100</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</P></BODY></HTML> Thu, 05 Nov 2015 14:59:09 GMT https://community.qlik.com/t5/QlikView/Help-With-Expression/m-p/1009001#M958889 Gysbert_Wassenaar 2015-11-05T14:59:09Z