topic What is wrong with this expression? in QlikView https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166194#M38223 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>Hey,</P><P></P><P>What's wrong with this?</P><P>=sum({$&lt;Fiscal_Quarter={$(#=(maxstring(Fiscal_Quarter)))}&gt;} Sales)</P><P>If i try this every works</P>=sum({$&lt;Fiscal_Year={$(#=(maxstring(Fiscal_Year)))}&gt;} Sales) <P>My dimension for both expresions is Fiscal_Quarter</P><P></P><P>tnx</P><BR /><BR /></BODY></HTML> Wed, 18 Aug 2010 14:51:13 GMT timmy 2010-08-18T14:51:13Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166194#M38223 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>Hey,</P><P></P><P>What's wrong with this?</P><P>=sum({$&lt;Fiscal_Quarter={$(#=(maxstring(Fiscal_Quarter)))}&gt;} Sales)</P><P>If i try this every works</P>=sum({$&lt;Fiscal_Year={$(#=(maxstring(Fiscal_Year)))}&gt;} Sales) <P>My dimension for both expresions is Fiscal_Quarter</P><P></P><P>tnx</P><BR /><BR /></BODY></HTML> Wed, 18 Aug 2010 14:51:13 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166194#M38223 timmy 2010-08-18T14:51:13Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166195#M38224 <HTML><HEAD></HEAD><BODY><P>Hi Timmy,</P><P>Maybe it doesn't work because you're trying to get a number with the "#="</P><P>What's the format of Fiscal_Quarter?</P><P></P><P></P></BODY></HTML> Wed, 18 Aug 2010 15:24:12 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166195#M38224 villafuerte 2010-08-18T15:24:12Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166196#M38225 <HTML><HEAD></HEAD><BODY><P>What do you mean by 'wrong'?</P></BODY></HTML> Wed, 18 Aug 2010 15:25:02 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166196#M38225 2010-08-18T15:25:02Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166197#M38226 <HTML><HEAD></HEAD><BODY><P>Your correct!</P><P>how can i perform this?</P><P></P><P>=sum({$&lt;Fiscal_Quarter={'Q' &amp; ' ' &amp; {$(=right(maxstring(Fiscal_Quarter),2))}&gt;} Sales)</P><BR /><BR /></BODY></HTML> Wed, 18 Aug 2010 15:34:40 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166197#M38226 timmy 2010-08-18T15:34:40Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166198#M38227 <HTML><HEAD></HEAD><BODY><P>Hi Timmy,</P><P></P><P>Can you upload an example file so we can see the formats and selection you want to display?</P><P></P><P>Cheers</P></BODY></HTML> Wed, 18 Aug 2010 18:58:50 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166198#M38227 villafuerte 2010-08-18T18:58:50Z What is wrong with this expression? https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166199#M38228 <HTML><HEAD></HEAD><BODY><P>The code you wrote had more or less the correct structure, but the string concatenation ( Q &amp; '' % ...) is also an operation, so you need to evaluate it before the comparison in the set analysis.</P><P>However it would be easier to show you with a mock file.</P><P></P><P>Cheers</P></BODY></HTML> Wed, 18 Aug 2010 19:13:39 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-expression/m-p/166199#M38228 villafuerte 2010-08-18T19:13:39Z