topic how to filter on pivot table without losing null dimensions in App Development https://community.qlik.com/t5/App-Development/how-to-filter-on-pivot-table-without-losing-null-dimensions/m-p/1547056#M39380 <P>I have a pivot table that has user access against modules.</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Analyse de risque</TD><TD>Analyse des Frais bancaires</TD><TD>Budget de trésorerie</TD><TD>Comptabilisation des Flux</TD><TD>Comptabilisation des Transactions Financières</TD><TD>Comptabilité de couverture</TD><TD>Données de marché</TD><TD>Echange de données</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD><TD>In-House Banking</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>-</TD></TR><TR><TD>ACOLONNA</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR><TR><TD>ADMIN</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to filter on a user without losing the modules that have null values. When I filter the result looks like this</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Comptabilisation des Flux</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD><TD>Netting</TD><TD>Paiements/Prélèvements</TD><TD>Portail</TD><TD>Pouvoirs Bancaires</TD><TD>Rapprochement Comptable</TD><TD>SCF Factures à Payer</TD><TD>SCF Payables - Portail Fournisseur</TD><TD>Tenue de Position</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please see the attachments in the file section. Output expected is below. All modules must be present even if it is null.</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Analyse de risque</TD><TD>Analyse des Frais bancaires</TD><TD>Budget de trésorerie</TD><TD>Comptabilisation des Flux</TD><TD>Comptabilisation des Transactions Financières</TD><TD>Comptabilité de couverture</TD><TD>Données de marché</TD><TD>Echange de données</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance</P> Wed, 20 Feb 2019 17:56:58 GMT meetblui 2019-02-20T17:56:58Z how to filter on pivot table without losing null dimensions https://community.qlik.com/t5/App-Development/how-to-filter-on-pivot-table-without-losing-null-dimensions/m-p/1547056#M39380 <P>I have a pivot table that has user access against modules.</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Analyse de risque</TD><TD>Analyse des Frais bancaires</TD><TD>Budget de trésorerie</TD><TD>Comptabilisation des Flux</TD><TD>Comptabilisation des Transactions Financières</TD><TD>Comptabilité de couverture</TD><TD>Données de marché</TD><TD>Echange de données</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD><TD>In-House Banking</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>-</TD></TR><TR><TD>ACOLONNA</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR><TR><TD>ADMIN</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to filter on a user without losing the modules that have null values. When I filter the result looks like this</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Comptabilisation des Flux</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD><TD>Netting</TD><TD>Paiements/Prélèvements</TD><TD>Portail</TD><TD>Pouvoirs Bancaires</TD><TD>Rapprochement Comptable</TD><TD>SCF Factures à Payer</TD><TD>SCF Payables - Portail Fournisseur</TD><TD>Tenue de Position</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please see the attachments in the file section. Output expected is below. All modules must be present even if it is null.</P><TABLE><TBODY><TR><TD>[User Code]</TD><TD>Module</TD><TD>Administration</TD><TD>Analyse de risque</TD><TD>Analyse des Frais bancaires</TD><TD>Budget de trésorerie</TD><TD>Comptabilisation des Flux</TD><TD>Comptabilisation des Transactions Financières</TD><TD>Comptabilité de couverture</TD><TD>Données de marché</TD><TD>Echange de données</TD><TD>Effets Clients</TD><TD>Effets Fournisseurs</TD><TD>Flux de Trésorerie &amp; Prévisions</TD><TD>Fraud &amp; Compliance</TD><TD>FX</TD></TR><TR><TD>ABTEST</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance</P> Wed, 20 Feb 2019 17:56:58 GMT https://community.qlik.com/t5/App-Development/how-to-filter-on-pivot-table-without-losing-null-dimensions/m-p/1547056#M39380 meetblui 2019-02-20T17:56:58Z