topic Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337310#M412384 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the dimensions I want Year value to always be greater than or equal to 2017.</P><P>Currently I have data from 2014.</P><P>It is possible to restrict the data in dimension level.</P><P><BR />Regards</P><P>Rahul</P></BODY></HTML> Wed, 02 Aug 2017 11:37:04 GMT rahulsingh12 2017-08-02T11:37:04Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337310#M412384 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the dimensions I want Year value to always be greater than or equal to 2017.</P><P>Currently I have data from 2014.</P><P>It is possible to restrict the data in dimension level.</P><P><BR />Regards</P><P>Rahul</P></BODY></HTML> Wed, 02 Aug 2017 11:37:04 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337310#M412384 rahulsingh12 2017-08-02T11:37:04Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337311#M412385 <HTML><HEAD></HEAD><BODY><P>May be use Calculated Dimension</P><P></P><P><STRONG>If(Year &gt;= 2017, Year)</STRONG> // Give it label as Year</P></BODY></HTML> Wed, 02 Aug 2017 11:38:51 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337311#M412385 Anil_Babu_Samineni 2017-08-02T11:38:51Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337312#M412386 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;Year={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(&gt;=(max(Year)))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} [Your Field]) </SPAN></P></BODY></HTML> Wed, 02 Aug 2017 11:41:28 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337312#M412386 senpradip007 2017-08-02T11:41:28Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337313#M412387 <HTML><HEAD></HEAD><BODY><P>Try this in your dimension</P><P></P><P>=if(Year&gt;=2017,Year)</P><P></P><P></P><P><IMG alt="year.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172199_year.png" style="height: auto;" /></P></BODY></HTML> Wed, 02 Aug 2017 11:50:32 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337313#M412387 prma7799 2017-08-02T11:50:32Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337314#M412388 <HTML><HEAD></HEAD><BODY><P>Why 2014 is not displaying in your case?</P></BODY></HTML> Wed, 02 Aug 2017 11:52:52 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337314#M412388 Anil_Babu_Samineni 2017-08-02T11:52:52Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337315#M412389 <HTML><HEAD></HEAD><BODY><P>By mistakenly I wrote 2014 in heading ..</P><P></P><P>Now correct it..</P></BODY></HTML> Wed, 02 Aug 2017 11:55:53 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1337315#M412389 prma7799 2017-08-02T11:55:53Z