topic Re: can you correct set expression? in QlikView https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654907#M239247 <HTML><HEAD></HEAD><BODY><P>Can you post sample app</P></BODY></HTML> Tue, 09 Sep 2014 13:07:04 GMT anbu1984 2014-09-09T13:07:04Z can you correct set expression? https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654903#M239243 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have designed Barchart. When user opened that chart need to show current Year data. after user selected previous year in year list box,same&nbsp; bar chart need to show previous data..how to write condition for that?</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i have used below expression</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Count({&lt;FiscalYear = {"$(=Max(FiscalYear)"}&gt;}[Type])</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">But few cases not working</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">is it correct?</P></BODY></HTML> Tue, 09 Sep 2014 11:57:42 GMT https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654903#M239243 balasundaram 2014-09-09T11:57:42Z Re: can you correct set expression? https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654904#M239244 <HTML><HEAD></HEAD><BODY><P>added a ) </P><P>=Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">FiscalYear</SPAN> = {"$(=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">FiscalYear</SPAN>) <STRONG>)</STRONG>"}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.7272720336914px;">Type</SPAN>)</P></BODY></HTML> Tue, 09 Sep 2014 12:13:59 GMT https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654904#M239244 maxgro 2014-09-09T12:13:59Z Re: can you correct set expression? https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654905#M239245 <HTML><HEAD></HEAD><BODY><P>COUNT({$&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">FiscalYear&nbsp; = {'$(=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">FiscalYear </SPAN>))'}</SPAN>&gt;}Type)</P></BODY></HTML> Tue, 09 Sep 2014 12:20:17 GMT https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654905#M239245 MK_QSL 2014-09-09T12:20:17Z Re: can you correct set expression? https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654906#M239246 <HTML><HEAD></HEAD><BODY><P>sory</P><P>Count({&lt;FiscalYearNum = {"$(=Max(FiscalYearNum))"}&gt;}[Type])</P><P></P><P>not working</P></BODY></HTML> Tue, 09 Sep 2014 12:22:11 GMT https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654906#M239246 balasundaram 2014-09-09T12:22:11Z Re: can you correct set expression? https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654907#M239247 <HTML><HEAD></HEAD><BODY><P>Can you post sample app</P></BODY></HTML> Tue, 09 Sep 2014 13:07:04 GMT https://community.qlik.com/t5/QlikView/can-you-correct-set-expression/m-p/654907#M239247 anbu1984 2014-09-09T13:07:04Z