topic Re: Size Calculated in QlikView https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601914#M544324 <HTML><HEAD></HEAD><BODY><P>se vuoi limitare la dimensione dataesecuzione puoi usare una dimensione calcolata e poi sopprimerla (flag) quando nulla</P><P>=if(dataesecuzione &gt;= addmonths(today(),-6)&nbsp; and dataesecuzione &lt;= addmonths(today(),12), dataesecuzione)</P></BODY></HTML> Tue, 22 Apr 2014 21:20:41 GMT maxgro 2014-04-22T21:20:41Z Size Calculated https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601912#M544322 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Good morning everyone.</SPAN> <BR /><BR /><SPAN class="hps">I have</SPAN> <SPAN class="hps">created a chart</SPAN> <SPAN class="hps">in Barre</SPAN> <SPAN class="hps">where I</SPAN> <SPAN class="hps">as</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">given</SPAN> <SPAN class="hps">dimension</SPAN> <SPAN class="atn hps">(</SPAN>data_esecuzione) <SPAN class="hps">and</SPAN> <SPAN class="hps">as an expression of</SPAN> <SPAN class="hps">a formula that</SPAN> <SPAN class="hps">performs</SPAN> <SPAN class="hps">calculations</SPAN> <SPAN class="hps">on</SPAN> <SPAN class="hps">other fields.</SPAN> <BR /><BR /><SPAN class="hps">in the database</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">dates</SPAN> <SPAN class="hps">ranging</SPAN> <SPAN class="hps">from 2009 to 2016</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">which the chart</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">have</SPAN> <SPAN class="hps">a lot of data</SPAN>. <BR /><BR /><SPAN class="hps">it is possible to</SPAN> <SPAN class="hps">calculate the size</SPAN> <SPAN class="hps">in order to</SPAN> <SPAN class="hps">consider</SPAN> <SPAN class="hps">only</SPAN> <SPAN class="hps">the dates</SPAN> <SPAN class="hps">ranging from</SPAN> <SPAN class="hps">dataesecuzione</SPAN> <SPAN class="hps">- 6</SPAN> <SPAN class="hps">months</SPAN> <SPAN class="hps">+ 12</SPAN> <SPAN class="hps">months from</SPAN> <SPAN class="hps">implementation</SPAN> <SPAN class="hps">date</SPAN> <SPAN class="hps">to today</SPAN>? <BR /><BR /><SPAN class="hps">thanks</SPAN> <BR /><BR /><SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Tue, 22 Apr 2014 07:06:48 GMT https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601912#M544322 warrentk80 2014-04-22T07:06:48Z Re: Size Calculated https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601913#M544323 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Use Monthdiff function (<A href="https://community.qlik.com/docs/DOC-3836">Calculating Months difference between two dates</A>)</SPAN></P><P></P><P>Use <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If( MonthDiff(Today(),DateField) &lt;=6 Or MonthDiff(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateField</SPAN>,Today() ) &lt;=12,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">data_esecuzione)</SPAN><BR /></SPAN></P></BODY></HTML> Tue, 22 Apr 2014 07:48:59 GMT https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601913#M544323 anbu1984 2014-04-22T07:48:59Z Re: Size Calculated https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601914#M544324 <HTML><HEAD></HEAD><BODY><P>se vuoi limitare la dimensione dataesecuzione puoi usare una dimensione calcolata e poi sopprimerla (flag) quando nulla</P><P>=if(dataesecuzione &gt;= addmonths(today(),-6)&nbsp; and dataesecuzione &lt;= addmonths(today(),12), dataesecuzione)</P></BODY></HTML> Tue, 22 Apr 2014 21:20:41 GMT https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601914#M544324 maxgro 2014-04-22T21:20:41Z Re: Size Calculated https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601915#M544325 <HTML><HEAD></HEAD><BODY><P>Ciao Massimo,</P><P></P><P>ho replicato la formula che mi hai indicato ed ora tutto funziona regolarmente.</P><P></P><P>Grazie 1000 per la collaborazione</P><P></P><P>Andrea</P></BODY></HTML> Wed, 23 Apr 2014 08:55:48 GMT https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601915#M544325 warrentk80 2014-04-23T08:55:48Z Re: Size Calculated https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601916#M544326 <HTML><HEAD></HEAD><BODY><P>se la risposta รจ corretta e/o utile, per favore marcala in modo che gli altri utenti del forum possono infividuarla; grazie</P></BODY></HTML> Wed, 23 Apr 2014 10:09:45 GMT https://community.qlik.com/t5/QlikView/Size-Calculated/m-p/601916#M544326 maxgro 2014-04-23T10:09:45Z