topic Delete columns with null values in App Development https://community.qlik.com/t5/App-Development/Delete-columns-with-null-values/m-p/1613030#M45632 <P>Facing challenge with delete columns with null values in Pivot group if its grouped under one label. Have dimension as units, two more dimensions for Period (MTD,QTD,Value) and Flows (Inflows, outflows) as inline table.&nbsp; Measures as Flows, Revenue. In some cases measure column is blank and we don't need them. Even though measure for blank columns are not added it is still showing as '-'.</P><P>so Pivot table looks like this :</P><P>Units&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aum</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inflows</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flows&nbsp;&nbsp; Revenue</P><P>&nbsp;</P><P>Appreciate any help.</P> Thu, 15 Aug 2019 18:42:23 GMT tellmalaika17 2019-08-15T18:42:23Z Delete columns with null values https://community.qlik.com/t5/App-Development/Delete-columns-with-null-values/m-p/1613030#M45632 <P>Facing challenge with delete columns with null values in Pivot group if its grouped under one label. Have dimension as units, two more dimensions for Period (MTD,QTD,Value) and Flows (Inflows, outflows) as inline table.&nbsp; Measures as Flows, Revenue. In some cases measure column is blank and we don't need them. Even though measure for blank columns are not added it is still showing as '-'.</P><P>so Pivot table looks like this :</P><P>Units&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aum</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inflows</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flows&nbsp;&nbsp; Revenue</P><P>&nbsp;</P><P>Appreciate any help.</P> Thu, 15 Aug 2019 18:42:23 GMT https://community.qlik.com/t5/App-Development/Delete-columns-with-null-values/m-p/1613030#M45632 tellmalaika17 2019-08-15T18:42:23Z Re: Delete columns with null values https://community.qlik.com/t5/App-Development/Delete-columns-with-null-values/m-p/1613303#M45668 <P>not completly clear on the challenge. share a sample app if you can</P> Fri, 16 Aug 2019 14:25:08 GMT https://community.qlik.com/t5/App-Development/Delete-columns-with-null-values/m-p/1613303#M45668 dplr-rn 2019-08-16T14:25:08Z