topic Line Chart QlikView in QlikView https://community.qlik.com/t5/QlikView/Line-Chart-QlikView/m-p/1387512#M813297 <HTML><HEAD></HEAD><BODY><P>hello ,</P><P><SPAN class="short_text" lang="en">the following calculation form</SPAN>:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">TU = sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Type de commande]</SPAN><SPAN style="font-size: 8pt;">, 'URGENT','GROS', 'PVI'), </SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° de commande]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: arial,helvetica,sans-serif;"><SPAN style="font-size: 10pt;">I want to draw a Line&nbsp; Chart of <SPAN style="color: #ff0000;">TU</SPAN> in relation to <SPAN style="color: #800000;">[N° donneur d'ordre]</SPAN></SPAN><SPAN><SPAN style="font-size: 10pt;">)&nbsp; Last 6 months&nbsp; of this year</SPAN> </SPAN></SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; font-family: Times New Roman;">Like this : </SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; font-family: Times New Roman;"><IMG __jive_id="177257" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177257_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT davidoxi 2020-11-25T16:16:04Z Line Chart QlikView https://community.qlik.com/t5/QlikView/Line-Chart-QlikView/m-p/1387512#M813297 <HTML><HEAD></HEAD><BODY><P>hello ,</P><P><SPAN class="short_text" lang="en">the following calculation form</SPAN>:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">TU = sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Type de commande]</SPAN><SPAN style="font-size: 8pt;">, 'URGENT','GROS', 'PVI'), </SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° de commande]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="color: #000000; font-size: 12pt; font-family: arial,helvetica,sans-serif;"><SPAN style="font-size: 10pt;">I want to draw a Line&nbsp; Chart of <SPAN style="color: #ff0000;">TU</SPAN> in relation to <SPAN style="color: #800000;">[N° donneur d'ordre]</SPAN></SPAN><SPAN><SPAN style="font-size: 10pt;">)&nbsp; Last 6 months&nbsp; of this year</SPAN> </SPAN></SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; font-family: Times New Roman;">Like this : </SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 8pt; font-family: Times New Roman;"><IMG __jive_id="177257" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177257_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Line-Chart-QlikView/m-p/1387512#M813297 davidoxi 2020-11-25T16:16:04Z