topic Re: Set analysis in dimmension? in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887579#M1004636 <HTML><HEAD></HEAD><BODY><P>How can i do a set expression if i have the value in a variable?</P></BODY></HTML> Tue, 19 May 2015 13:18:32 GMT 2015-05-19T13:18:32Z Set analysis in dimmension? https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887577#M1004634 <HTML><HEAD></HEAD><BODY><P>Hi in the app i have Year.</P><P>You can select only one year, and you must always have 1 year selected</P><P>In a table i wanna have all the years in the dimmension</P><P>what should i do?</P><P>Thank you</P><P>Greetings.</P></BODY></HTML> Tue, 19 May 2015 13:12:08 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887577#M1004634 2015-05-19T13:12:08Z Re: Set analysis in dimmension? https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887578#M1004635 <HTML><HEAD></HEAD><BODY><P>Set expressions should be used in expressions. The dimension will expand based on the set expression you apply in the expression.</P><P></P><P>For example this set expression will deselect the year in your calculation...</P><P></P><P>=sum( {&lt;Year=&gt;} MyField)</P></BODY></HTML> Tue, 19 May 2015 13:16:45 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887578#M1004635 ToniKautto 2015-05-19T13:16:45Z Re: Set analysis in dimmension? https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887579#M1004636 <HTML><HEAD></HEAD><BODY><P>How can i do a set expression if i have the value in a variable?</P></BODY></HTML> Tue, 19 May 2015 13:18:32 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887579#M1004636 2015-05-19T13:18:32Z Re: Set analysis in dimmension? https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887580#M1004637 <HTML><HEAD></HEAD><BODY><P>What value are you referring to? </P><P></P><P>You mean like this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=sum( {&lt;Year={"$(vMyVariable)"}&gt;} MyField)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Notice that the variable will not actually vary within the chart, instead it will be expanded prior to the expression being evaluated. <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><A href="https://community.qlik.com/docs/DOC-8490">Set expression and dollar expansion</A><BR /></SPAN></P></BODY></HTML> Tue, 19 May 2015 13:36:18 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-dimmension/m-p/887580#M1004637 ToniKautto 2015-05-19T13:36:18Z