topic Re: graphic Mixed in QlikView https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036935#M526159 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Script:</P><P></P><P><STRONG>SET LongMonthNames='Gennaio;Febbraio;Marzo;Aprile;Maggio;Giugno;Luglio;Agosto;Settembre;Ottobre;Novembre;Dicembre';</STRONG></P><P></P><P><STRONG>LOAD Month(Serie) as Month, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Vendite</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>[esempio.xlsx]</STRONG></P><P><STRONG>(ooxml, embedded labels, table is Lines);</STRONG></P><P></P><P><STRONG>LOAD Month(Date#(Mese, 'MMMM')) as Month, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Acquisti</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>[esempio.xlsx]</STRONG></P><P><STRONG>(ooxml, embedded labels, table is Istogramma);</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112123_Capture.PNG" style="height: 284px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 20 Jan 2016 14:41:02 GMT sunny_talwar 2016-01-20T14:41:02Z graphic Mixed https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036932#M526156 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Goodmorning everyone</SPAN><BR /><BR /> <SPAN class="hps">I</SPAN> <SPAN class="hps">need to build</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">mixed chart</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">bar</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">linear</SPAN> <SPAN class="hps">representation</SPAN>.<BR /><BR /> <SPAN class="hps">the size</SPAN> <SPAN class="hps">of the measures</SPAN> <SPAN class="hps">on which</SPAN> <SPAN class="hps">I make</SPAN> <SPAN class="hps">the calculations</SPAN> <SPAN class="hps">are different.</SPAN><BR /><BR /><BR /> <SPAN class="hps">someone</SPAN> <SPAN class="hps">would know</SPAN> <SPAN class="hps">tell me how to</SPAN> <SPAN class="hps">do?</SPAN><BR /><BR /> <SPAN class="hps">send</SPAN> <SPAN class="hps">attached</SPAN> <SPAN class="hps">files</SPAN> <SPAN class="hps">database</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">excel</SPAN>, <SPAN class="hps">dashboard</SPAN> <SPAN class="hps">example of</SPAN> <SPAN class="hps">what I did</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">picture</SPAN> <SPAN class="hps">of what</SPAN> <SPAN class="hps">I want</SPAN>.<BR /><BR /> <SPAN class="hps">Thank you</SPAN><BR /><BR /> <SPAN class="hps">Andrea</SPAN></SPAN></P></BODY></HTML> Wed, 20 Jan 2016 14:13:01 GMT https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036932#M526156 warrentk80 2016-01-20T14:13:01Z Re: graphic Mixed https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036933#M526157 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">sorry</SPAN> <SPAN class="hps">attachments</SPAN></SPAN></P></BODY></HTML> Wed, 20 Jan 2016 14:14:39 GMT https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036933#M526157 warrentk80 2016-01-20T14:14:39Z Re: graphic Mixed https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036934#M526158 <HTML><HEAD></HEAD><BODY><P>Your two tables are not linked with each other.. How you want to show their fields in one chart?</P></BODY></HTML> Wed, 20 Jan 2016 14:24:32 GMT https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036934#M526158 MK_QSL 2016-01-20T14:24:32Z Re: graphic Mixed https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036935#M526159 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Script:</P><P></P><P><STRONG>SET LongMonthNames='Gennaio;Febbraio;Marzo;Aprile;Maggio;Giugno;Luglio;Agosto;Settembre;Ottobre;Novembre;Dicembre';</STRONG></P><P></P><P><STRONG>LOAD Month(Serie) as Month, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Vendite</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>[esempio.xlsx]</STRONG></P><P><STRONG>(ooxml, embedded labels, table is Lines);</STRONG></P><P></P><P><STRONG>LOAD Month(Date#(Mese, 'MMMM')) as Month, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Acquisti</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>[esempio.xlsx]</STRONG></P><P><STRONG>(ooxml, embedded labels, table is Istogramma);</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112123_Capture.PNG" style="height: 284px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 20 Jan 2016 14:41:02 GMT https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036935#M526159 sunny_talwar 2016-01-20T14:41:02Z Re: graphic Mixed https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036936#M526160 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">I modified</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">basic</SPAN> <SPAN class="hps">dates</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">dimension</SPAN> <SPAN class="hps">in common</SPAN> <SPAN class="hps atn">(</SPAN>codicemese)<BR /> <SPAN class="hps">in the bar graph</SPAN> <SPAN class="hps">does not show all</SPAN> <SPAN class="hps">the months</SPAN>, <SPAN class="hps">but only those</SPAN> <SPAN class="hps">which</SPAN> <SPAN class="hps">have been made</SPAN> <SPAN class="hps">both</SPAN> <SPAN class="hps">sales and</SPAN> <SPAN class="hps">purchases</SPAN>.<BR /><BR /> <SPAN class="hps">Thank you</SPAN><BR /><BR /> <SPAN class="hps">Andrea</SPAN><BR /><BR /> <SPAN class="hps">attached</SPAN> <SPAN class="hps">example</SPAN></SPAN></P></BODY></HTML> Wed, 20 Jan 2016 14:50:13 GMT https://community.qlik.com/t5/QlikView/graphic-Mixed/m-p/1036936#M526160 warrentk80 2016-01-20T14:50:13Z