topic Multi Box in Francophones https://community.qlik.com/t5/Francophones/Multi-Box/m-p/118015#M1983 <HTML><HEAD></HEAD><BODY><P><SPAN class="un" style="background-color: #fefeaf; color: #32485f; font-family: Montserrat, Arial, 'sans serif'; font-size: 14px;">Bonjour</SPAN><SPAN style="color: #32485f; font-family: Montserrat, Arial, 'sans serif'; font-size: 14px;"> la comminauté .</SPAN></P><P></P><P>J'ai une table au niveau de la base de données : table PNL.</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 800px; height: 156px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">B</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">C</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">D</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">E</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">F</TH></TR><TR><TD style="padding: 2px;">a1</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">c1</TD><TD style="padding: 2px;">d1</TD><TD style="padding: 2px;">e1</TD><TD style="padding: 2px;">f1</TD></TR><TR><TD style="padding: 2px;">a2</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">c2</TD><TD style="padding: 2px;">d2</TD><TD style="padding: 2px;">e2</TD><TD style="padding: 2px;">f2</TD></TR><TR><TD style="padding: 2px;">a3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c3</TD><TD style="padding: 2px;">d3</TD><TD style="padding: 2px;">e3</TD><TD style="padding: 2px;">f3</TD></TR><TR><TD style="padding: 2px;">a4</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">c4</TD><TD style="padding: 2px;">d4</TD><TD style="padding: 2px;">e4</TD><TD style="padding: 2px;">f4</TD></TR><TR><TD style="padding: 2px;">a5</TD><TD style="padding: 2px;">36</TD><TD style="padding: 2px;">c5</TD><TD style="padding: 2px;">d5</TD><TD style="padding: 2px;">e5</TD><TD style="padding: 2px;">f5</TD></TR><TR><TD style="padding: 2px;">a6</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">c6</TD><TD style="padding: 2px;">d6</TD><TD style="padding: 2px;">e6</TD><TD style="padding: 2px;">f6</TD></TR></TBODY></TABLE><P></P><P>1.j'utilise le <SPAN style="font-weight: 640; color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">Multi Box</SPAN> Qlikview pour <SPAN style="font-size: 10pt;">représente la liste de toutes les valeurs de toutes les champs en tant que listes déroulantes.</SPAN></P><P></P><P>voici le script de chargement:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "A",</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "C",</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "D"</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "E"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "F"</P><P>SQL SELECT</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "a" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "A",</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "b" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "<STRONG>B</STRONG>"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "c" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "C"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "d" as&nbsp;&nbsp;&nbsp;&nbsp; "D"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "e" as&nbsp;&nbsp;&nbsp;&nbsp; "E"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "f"&nbsp; as&nbsp;&nbsp;&nbsp;&nbsp; "F"</P><P>&nbsp;&nbsp;&nbsp; </P><P>FROM&nbsp;&nbsp;&nbsp; "PNT";</P><P>==&gt;&nbsp;&nbsp; ça&nbsp; c'est&nbsp; bon&nbsp; je&nbsp; peux voir&nbsp; toutes&nbsp; les&nbsp; valeurs&nbsp;&nbsp; de&nbsp; toutes&nbsp; les&nbsp; champs&nbsp; dans&nbsp; le&nbsp; Multi Box.</P><P>==&gt;&nbsp; problème : actuellement&nbsp; les lignes c3 et c4 de la colonne <STRONG>C</STRONG> n existe plus,mais je ne voudrais<SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pas </SPAN><SPAN style="font-size: 10pt;">supprimer leur donnes .par contre&nbsp; je dois avoir un liste de selection :c_old&nbsp; dans la meme </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">Multi Box</SPAN><SPAN style="font-size: 10pt;"> qui contient ces lignes(c3 et c4).</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Est ce que c'est possible de faire ça ?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">merci d'avance</SPAN></P></BODY></HTML> Thu, 18 Oct 2018 16:44:26 GMT mhdecision 2018-10-18T16:44:26Z Multi Box https://community.qlik.com/t5/Francophones/Multi-Box/m-p/118015#M1983 <HTML><HEAD></HEAD><BODY><P><SPAN class="un" style="background-color: #fefeaf; color: #32485f; font-family: Montserrat, Arial, 'sans serif'; font-size: 14px;">Bonjour</SPAN><SPAN style="color: #32485f; font-family: Montserrat, Arial, 'sans serif'; font-size: 14px;"> la comminauté .</SPAN></P><P></P><P>J'ai une table au niveau de la base de données : table PNL.</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 800px; height: 156px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">B</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">C</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">D</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">E</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">F</TH></TR><TR><TD style="padding: 2px;">a1</TD><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">c1</TD><TD style="padding: 2px;">d1</TD><TD style="padding: 2px;">e1</TD><TD style="padding: 2px;">f1</TD></TR><TR><TD style="padding: 2px;">a2</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">c2</TD><TD style="padding: 2px;">d2</TD><TD style="padding: 2px;">e2</TD><TD style="padding: 2px;">f2</TD></TR><TR><TD style="padding: 2px;">a3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c3</TD><TD style="padding: 2px;">d3</TD><TD style="padding: 2px;">e3</TD><TD style="padding: 2px;">f3</TD></TR><TR><TD style="padding: 2px;">a4</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">c4</TD><TD style="padding: 2px;">d4</TD><TD style="padding: 2px;">e4</TD><TD style="padding: 2px;">f4</TD></TR><TR><TD style="padding: 2px;">a5</TD><TD style="padding: 2px;">36</TD><TD style="padding: 2px;">c5</TD><TD style="padding: 2px;">d5</TD><TD style="padding: 2px;">e5</TD><TD style="padding: 2px;">f5</TD></TR><TR><TD style="padding: 2px;">a6</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">c6</TD><TD style="padding: 2px;">d6</TD><TD style="padding: 2px;">e6</TD><TD style="padding: 2px;">f6</TD></TR></TBODY></TABLE><P></P><P>1.j'utilise le <SPAN style="font-weight: 640; color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">Multi Box</SPAN> Qlikview pour <SPAN style="font-size: 10pt;">représente la liste de toutes les valeurs de toutes les champs en tant que listes déroulantes.</SPAN></P><P></P><P>voici le script de chargement:</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "A",</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "C",</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "D"</P><P>&nbsp;&nbsp;&nbsp;&nbsp; "E"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "F"</P><P>SQL SELECT</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "a" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "A",</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "b" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "<STRONG>B</STRONG>"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "c" as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "C"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "d" as&nbsp;&nbsp;&nbsp;&nbsp; "D"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "e" as&nbsp;&nbsp;&nbsp;&nbsp; "E"</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "f"&nbsp; as&nbsp;&nbsp;&nbsp;&nbsp; "F"</P><P>&nbsp;&nbsp;&nbsp; </P><P>FROM&nbsp;&nbsp;&nbsp; "PNT";</P><P>==&gt;&nbsp;&nbsp; ça&nbsp; c'est&nbsp; bon&nbsp; je&nbsp; peux voir&nbsp; toutes&nbsp; les&nbsp; valeurs&nbsp;&nbsp; de&nbsp; toutes&nbsp; les&nbsp; champs&nbsp; dans&nbsp; le&nbsp; Multi Box.</P><P>==&gt;&nbsp; problème : actuellement&nbsp; les lignes c3 et c4 de la colonne <STRONG>C</STRONG> n existe plus,mais je ne voudrais<SPAN style="font-size: 10pt;"> </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pas </SPAN><SPAN style="font-size: 10pt;">supprimer leur donnes .par contre&nbsp; je dois avoir un liste de selection :c_old&nbsp; dans la meme </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-size: 13.3333px;">Multi Box</SPAN><SPAN style="font-size: 10pt;"> qui contient ces lignes(c3 et c4).</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Est ce que c'est possible de faire ça ?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">merci d'avance</SPAN></P></BODY></HTML> Thu, 18 Oct 2018 16:44:26 GMT https://community.qlik.com/t5/Francophones/Multi-Box/m-p/118015#M1983 mhdecision 2018-10-18T16:44:26Z