topic Suppress Pivot Expansion when dimension is null (unclean data) in QlikView https://community.qlik.com/t5/QlikView/Suppress-Pivot-Expansion-when-dimension-is-null-unclean-data/m-p/460771#M172016 <HTML><HEAD></HEAD><BODY><P>Hi there everybody,</P><P></P><P>just a usual data-modelling phenomenon. Sometimes entered data have subcategories, subsubcategories etc. and sometimes they don't.</P><P></P><P>When displaying the data in an expandable pivot-table, those null-values mess up with my expansion/collapse-philosophy. I see an [+] only to find out that dimensions expand with null()-values. I've spent many hours searching and trying different alternatives.</P><P></P><P>See the attached .qvw - file.</P><P></P><P></P><P>Your help is greatly appreciated.</P><P></P><P>Sincerely,</P><P>Martin</P></BODY></HTML> Thu, 22 Nov 2012 23:57:02 GMT simondachstr 2012-11-22T23:57:02Z Suppress Pivot Expansion when dimension is null (unclean data) https://community.qlik.com/t5/QlikView/Suppress-Pivot-Expansion-when-dimension-is-null-unclean-data/m-p/460771#M172016 <HTML><HEAD></HEAD><BODY><P>Hi there everybody,</P><P></P><P>just a usual data-modelling phenomenon. Sometimes entered data have subcategories, subsubcategories etc. and sometimes they don't.</P><P></P><P>When displaying the data in an expandable pivot-table, those null-values mess up with my expansion/collapse-philosophy. I see an [+] only to find out that dimensions expand with null()-values. I've spent many hours searching and trying different alternatives.</P><P></P><P>See the attached .qvw - file.</P><P></P><P></P><P>Your help is greatly appreciated.</P><P></P><P>Sincerely,</P><P>Martin</P></BODY></HTML> Thu, 22 Nov 2012 23:57:02 GMT https://community.qlik.com/t5/QlikView/Suppress-Pivot-Expansion-when-dimension-is-null-unclean-data/m-p/460771#M172016 simondachstr 2012-11-22T23:57:02Z Re: Suppress Pivot Expansion when dimension is null (unclean data) https://community.qlik.com/t5/QlikView/Suppress-Pivot-Expansion-when-dimension-is-null-unclean-data/m-p/460772#M172017 <HTML><HEAD></HEAD><BODY><P>It's simply not possible I'm afraid.</P></BODY></HTML> Fri, 23 Nov 2012 10:21:47 GMT https://community.qlik.com/t5/QlikView/Suppress-Pivot-Expansion-when-dimension-is-null-unclean-data/m-p/460772#M172017 Gysbert_Wassenaar 2012-11-23T10:21:47Z