topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1211647#M388575 <HTML><HEAD></HEAD><BODY><P>I have an expression, =NUM(min(transBASEPRICE),'$#,###.') that I would like to include another variable to. I want to know the 'transBASEPRICE' when the 'transBUYERTYPE' is ADULT.</P><P></P><P>What would the correct syntax be for that.</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 07 Nov 2016 16:36:20 GMT evansabres 2016-11-07T16:36:20Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1211647#M388575 <HTML><HEAD></HEAD><BODY><P>I have an expression, =NUM(min(transBASEPRICE),'$#,###.') that I would like to include another variable to. I want to know the 'transBASEPRICE' when the 'transBUYERTYPE' is ADULT.</P><P></P><P>What would the correct syntax be for that.</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 07 Nov 2016 16:36:20 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1211647#M388575 evansabres 2016-11-07T16:36:20Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1211648#M388576 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=NUM(min({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">transBUYERTYPE={ADULT}</SPAN>&gt;}transBASEPRICE),'$#,###.')</SPAN></P></BODY></HTML> Mon, 07 Nov 2016 16:40:01 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1211648#M388576 Nicole-Smith 2016-11-07T16:40:01Z