topic Re: Expression not working ? in QlikView https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312638#M833562 <HTML><HEAD></HEAD><BODY><P>Hi Suvechha,</P><P></P><P>What would be an expected output for this expression with this product selected?</P><P>There's not much to go on here with only the screenshot.</P><P></P><P>Below is what I get when I open the provided app and only thing I can tell is that you don't have the "period_key" field with the values you need on the loaded tables.</P><P><IMG __jive_id="165789" alt="Sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165789_Sample.png" style="height: 349px; width: 620px;" /></P><P>Only value for the field is 190 and your expression is giving period_key &gt;=187 and &lt;= 189 from the set analysis</P><P></P><P>Felipe.</P></BODY></HTML> Mon, 05 Jun 2017 14:00:52 GMT felipedl 2017-06-05T14:00:52Z Expression not working ? https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312637#M833561 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>Please suggest why the expression is not working - "Prev 3 months Sales Units".</P><P></P><P>as mentioned in the screenshot.</P><P></P><P><IMG alt="Capture3.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165781_Capture3.PNG" style="height: 145px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312637#M833561 suvechha_b 2020-11-25T16:16:04Z Re: Expression not working ? https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312638#M833562 <HTML><HEAD></HEAD><BODY><P>Hi Suvechha,</P><P></P><P>What would be an expected output for this expression with this product selected?</P><P>There's not much to go on here with only the screenshot.</P><P></P><P>Below is what I get when I open the provided app and only thing I can tell is that you don't have the "period_key" field with the values you need on the loaded tables.</P><P><IMG __jive_id="165789" alt="Sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165789_Sample.png" style="height: 349px; width: 620px;" /></P><P>Only value for the field is 190 and your expression is giving period_key &gt;=187 and &lt;= 189 from the set analysis</P><P></P><P>Felipe.</P></BODY></HTML> Mon, 05 Jun 2017 14:00:52 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312638#M833562 felipedl 2017-06-05T14:00:52Z Re: Expression not working ? https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312639#M833563 <HTML><HEAD></HEAD><BODY><P>I agree with Felipe. You need to load more data. The QVW you attached has only two dates in your Date/Calendar table.</P><P>Also you have synthetic keys in the data model that you might need&nbsp; to fix.</P></BODY></HTML> Mon, 05 Jun 2017 15:13:17 GMT https://community.qlik.com/t5/QlikView/Expression-not-working/m-p/1312639#M833563 sudeepkm 2017-06-05T15:13:17Z