topic Re: Aggr in QlikView https://community.qlik.com/t5/QlikView/Aggr/m-p/1423350#M429067 <HTML><HEAD></HEAD><BODY><P>Une autre possibilité serait l'utilisation de la fonction <A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/alt.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/alt.htm">Alt()</A></P><P><IMG __jive_id="187428" alt="QlikCommunity_Thread_285442_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187428_QlikCommunity_Thread_285442_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15136345225258417" jivemacro_uid="_15136345225258417"> <P>table1:</P> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp; Alt([Cot moy Sim],[Cot moy]) as [Cot moy Sim compl];</P> <P>LOAD Code_Commune,</P> <P>&nbsp;&nbsp;&nbsp; Money#([Cot moy]) as [Cot moy],</P> <P>&nbsp;&nbsp;&nbsp; Money#([Cot moy Sim]) as [Cot moy Sim]</P> <P><SPAN>FROM [</SPAN><A _jive_internal="true" data-containerid="2051" data-containertype="14" data-objectid="285442" data-objecttype="1" href="https://community.qlik.com/thread/285442">https://community.qlik.com/thread/285442</A><SPAN>] (html, codepage is 1252, embedded labels, table is @1);</SPAN></P> </PRE><P></P><P>cordialement</P><P></P><P>Marco</P></BODY></HTML> Mon, 18 Dec 2017 22:02:17 GMT MarcoWedel 2017-12-18T22:02:17Z Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1423348#M429065 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Je rencontre un problématique qui devrait certainement trouver une réponse via les notions 'AGGR'.</P><P></P><P>J'ai le tableau suivant:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD class="xl65" height="17" width="107">Code_Commune</TD><TD class="xl65" style="border-left: none;" width="63">Cot moy</TD><TD class="xl65" style="border-left: none;" width="86">Cot moy Sim</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01141</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">34,73 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">37,48 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01429</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">39,68 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01264</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">43,32 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01402</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">37,44 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">40,55 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01204</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">53,97 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">57,43 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01197</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40,72 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01067</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38,96 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">42,16 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01346</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">45,15 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01227</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42,08 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">45,73 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01405</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">44,02 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01442</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">51,12 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">55,08 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01212</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">46,30 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01033</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">47,82 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">51,80 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01266</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38,23 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01077</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">51,11 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">55,64 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01114</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">54,33 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">59,13 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01441</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40,47 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">43,77 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01254</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42,43 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01330</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31,44 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">33,70 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01372</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">45,28 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">49,31 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01415</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">55,15 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">59,92 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01036</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">44,51 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">48,21 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01228</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">44,51 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">48,20 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01232</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40,56 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01321</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42,79 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01130</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40,20 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01331</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">46,30 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">49,95 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01034</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38,17 €</TD><TD class="xl69" style="border-top: none; border-left: none;"></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01012</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40,57 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">43,94 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">01265</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42,70 €</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">46,29 €</TD></TR></TBODY></TABLE><P></P><P>Je voudrais mettre en place le tableau équivalent, mais avec la dimension 'Code_Departement',</P><P>mais avant cela, j'aurais besoin de compléter le champ 'Cot Moy sim' qui n'est pas rempli partout.</P><P>Le principe serait de remplir les code commune vide avec le champ 'Cot Moy'.</P><P>Je ne sais pas si j'ai été claire, par rapport à ma problématique?</P><P></P><P>Merci à vous pour votre retour,</P><P></P><P>Bien cordialement,</P><P></P><P>Willy</P></BODY></HTML> Mon, 18 Dec 2017 16:54:04 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1423348#M429065 Anonymous 2017-12-18T16:54:04Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1423349#M429066 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15136210242422540 jive_text_macro" jivemacro_uid="_15136210242422540"> <P>LOAD Code_Commune, </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; [Cot moy], </P> <P>&nbsp;&nbsp;&nbsp;&nbsp; [Cot moy Sim],</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; if([Cot moy Sim],[Cot moy Sim],[Cot moy]) as [Cot moy Sim_1]</P> <P>FROM</P> <P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2051" data-containertype="14" data-objectid="285442" data-objecttype="1" href="https://community.qlik.com/thread/285442">https://community.qlik.com/thread/285442</A><SPAN>]</SPAN></P> <P>(html, codepage is 1252, embedded labels, table is @1);</P> </PRE><P></P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187400_Unbenannt.png" style="height: auto;" /></P></BODY></HTML> Mon, 18 Dec 2017 18:18:17 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1423349#M429066 Frank_Hartmann 2017-12-18T18:18:17Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1423350#M429067 <HTML><HEAD></HEAD><BODY><P>Une autre possibilité serait l'utilisation de la fonction <A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/alt.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/alt.htm">Alt()</A></P><P><IMG __jive_id="187428" alt="QlikCommunity_Thread_285442_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187428_QlikCommunity_Thread_285442_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15136345225258417" jivemacro_uid="_15136345225258417"> <P>table1:</P> <P>LOAD *,</P> <P>&nbsp;&nbsp;&nbsp; Alt([Cot moy Sim],[Cot moy]) as [Cot moy Sim compl];</P> <P>LOAD Code_Commune,</P> <P>&nbsp;&nbsp;&nbsp; Money#([Cot moy]) as [Cot moy],</P> <P>&nbsp;&nbsp;&nbsp; Money#([Cot moy Sim]) as [Cot moy Sim]</P> <P><SPAN>FROM [</SPAN><A _jive_internal="true" data-containerid="2051" data-containertype="14" data-objectid="285442" data-objecttype="1" href="https://community.qlik.com/thread/285442">https://community.qlik.com/thread/285442</A><SPAN>] (html, codepage is 1252, embedded labels, table is @1);</SPAN></P> </PRE><P></P><P>cordialement</P><P></P><P>Marco</P></BODY></HTML> Mon, 18 Dec 2017 22:02:17 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1423350#M429067 MarcoWedel 2017-12-18T22:02:17Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1423351#M429068 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P></P><P>Merci beaucoup,</P><P></P><P>Willy LEPANTE</P></BODY></HTML> Tue, 19 Dec 2017 13:50:22 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1423351#M429068 Anonymous 2017-12-19T13:50:22Z