topic TCD afficher colonne selon condition in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/TCD-afficher-colonne-selon-condition/m-p/1931041#M211 <P>Bonjour à tous,</P> <P>J'ai réalisé un TCD&nbsp;de ce genre dan&nbsp;<LI-PRODUCT title="Qlik Sense Business" id="qlikSenseBusiness"></LI-PRODUCT>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 372pt;" border="0" width="487px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt; width: 62pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65" style="width: 62pt;">&nbsp;</TD> <TD colspan="2" width="163.271px" height="14px" class="xl65" style="width: 124pt;">2022</TD> <TD colspan="2" width="163.302px" height="14px" class="xl65" style="width: 124pt;">2021</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px">&nbsp;</TD> <TD width="94.8021px" height="14px" class="xl65">Quantité</TD> <TD width="68.4688px" height="14px" class="xl65">VS N-1</TD> <TD width="97.6354px" height="14px" class="xl65">Quantité</TD> <TD width="65.6667px" height="14px" class="xl65">VS N-1</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">A</TD> <TD width="87.3438px" height="14px" class="xl65">JANVIER</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65">FEVRIER</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65">MARS</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>J'aimerais afficher la colonne "VS N-1"&nbsp; uniquement pour l'année en cours soit uniquement pour l'année 2022 en ce moment et donc obtenir cela :</P> <TABLE style="border-collapse: collapse;" border="0" width="500px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt; width: 62pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65" style="width: 62pt;">&nbsp;</TD> <TD colspan="2" width="164.625px" height="14px" class="xl65" style="width: 124pt;">2022</TD> <TD width="164.177px" height="14px" class="xl65" style="width: 124pt;">2021</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px">&nbsp;</TD> <TD width="95.4375px" height="14px" class="xl65">Quantité</TD> <TD width="69.1875px" height="14px" class="xl65">VS N-1</TD> <TD width="164.177px" height="14px" class="xl65">Quantité</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">A</TD> <TD width="87.7396px" height="14px" class="xl65">JANVIER</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65">FEVRIER</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65">MARS</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>J'ai testé de mettre une condition d'affichage de la colonne grâce à une expression (year(Today())=Année mais cela s'applique aux 2 colonnes "VS N-1".</P> <P>Je vous remercie de votre aide,</P> <P>No</P> Fri, 15 Nov 2024 22:11:20 GMT hello_one 2024-11-15T22:11:20Z TCD afficher colonne selon condition https://community.qlik.com/t5/Reporting-Service-Alerting/TCD-afficher-colonne-selon-condition/m-p/1931041#M211 <P>Bonjour à tous,</P> <P>J'ai réalisé un TCD&nbsp;de ce genre dan&nbsp;<LI-PRODUCT title="Qlik Sense Business" id="qlikSenseBusiness"></LI-PRODUCT>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 372pt;" border="0" width="487px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt; width: 62pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65" style="width: 62pt;">&nbsp;</TD> <TD colspan="2" width="163.271px" height="14px" class="xl65" style="width: 124pt;">2022</TD> <TD colspan="2" width="163.302px" height="14px" class="xl65" style="width: 124pt;">2021</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px">&nbsp;</TD> <TD width="94.8021px" height="14px" class="xl65">Quantité</TD> <TD width="68.4688px" height="14px" class="xl65">VS N-1</TD> <TD width="97.6354px" height="14px" class="xl65">Quantité</TD> <TD width="65.6667px" height="14px" class="xl65">VS N-1</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">A</TD> <TD width="87.3438px" height="14px" class="xl65">JANVIER</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65">FEVRIER</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="81.0833px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.3438px" height="14px" class="xl65">MARS</TD> <TD width="94.8021px" height="14px">&nbsp;</TD> <TD width="68.4688px" height="14px">&nbsp;</TD> <TD width="97.6354px" height="14px">&nbsp;</TD> <TD width="65.6667px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>J'aimerais afficher la colonne "VS N-1"&nbsp; uniquement pour l'année en cours soit uniquement pour l'année 2022 en ce moment et donc obtenir cela :</P> <TABLE style="border-collapse: collapse;" border="0" width="500px" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt; width: 62pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65" style="width: 62pt;">&nbsp;</TD> <TD colspan="2" width="164.625px" height="14px" class="xl65" style="width: 124pt;">2022</TD> <TD width="164.177px" height="14px" class="xl65" style="width: 124pt;">2021</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px">&nbsp;</TD> <TD width="95.4375px" height="14px" class="xl65">Quantité</TD> <TD width="69.1875px" height="14px" class="xl65">VS N-1</TD> <TD width="164.177px" height="14px" class="xl65">Quantité</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">A</TD> <TD width="87.7396px" height="14px" class="xl65">JANVIER</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65">FEVRIER</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> <TR style="height: 14.4pt;"> <TD width="82.4583px" height="14px" class="xl65" style="height: 14.4pt;">&nbsp;</TD> <TD width="87.7396px" height="14px" class="xl65">MARS</TD> <TD width="95.4375px" height="14px">&nbsp;</TD> <TD width="69.1875px" height="14px">&nbsp;</TD> <TD width="164.177px" height="14px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>J'ai testé de mettre une condition d'affichage de la colonne grâce à une expression (year(Today())=Année mais cela s'applique aux 2 colonnes "VS N-1".</P> <P>Je vous remercie de votre aide,</P> <P>No</P> Fri, 15 Nov 2024 22:11:20 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/TCD-afficher-colonne-selon-condition/m-p/1931041#M211 hello_one 2024-11-15T22:11:20Z