topic Re: Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/117985#M18179 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data with expected output and any qvw file please upload will work on it. ?</P></BODY></HTML> Thu, 18 Oct 2018 16:12:47 GMT vishsaggi 2018-10-18T16:12:47Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/117984#M18178 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am attempting to create a table that has a dimension of 'Event Date' and 10 expressions that are all similarly structured.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">My end goal is to have a value that is the price per ticket paid, based on the total sale divided by the total quantity sold.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">My initial expression is: =NUM(avg({$&lt;PRICESCALE={"200 Club End"}&gt;}[TOTALSALE]), '$#,###.') which is giving me the average price of the 'TOTALSALE' when the 'PRICESCALE' is 200 Club End. However, I need to introduce the following count(seatnumber) to divide by the initial expression to result in the average price paid</P></BODY></HTML> Thu, 18 Oct 2018 15:31:14 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/117984#M18178 evansabres 2018-10-18T15:31:14Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/117985#M18179 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data with expected output and any qvw file please upload will work on it. ?</P></BODY></HTML> Thu, 18 Oct 2018 16:12:47 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/117985#M18179 vishsaggi 2018-10-18T16:12:47Z