topic Re: exclude categories from column in QlikView

topic Re: exclude categories from column in QlikView https://community.qlik.com/t5/QlikView/exclude-categories-from-column/m-p/116532#M1292438 <HTML><HEAD></HEAD><BODY><P>Use calculated dimension. Expression: If(Categories<>'Color', Categories)</P><P></P><P>And, enable 'Suppress When Value Is Null' in dimension tab</P></BODY></HTML> Fri, 28 Sep 2018 05:17:35 GMT tresB 2018-09-28T05:17:35Z exclude categories from column https://community.qlik.com/t5/QlikView/exclude-categories-from-column/m-p/116531#M1292435 <HTML><HEAD></HEAD><BODY><P>i have one dimension in pivot table like this </P><P></P><P>Categories</P><P>Wood</P><P>Color</P><P>Crockery</P><P>Laptops</P><P></P><P>here i want to exclude color category from column what i should do ?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/exclude-categories-from-column/m-p/116531#M1292435 capriconuser 2026-01-26T18:19:17Z Re: exclude categories from column https://community.qlik.com/t5/QlikView/exclude-categories-from-column/m-p/116532#M1292438 <HTML><HEAD></HEAD><BODY><P>Use calculated dimension. Expression: If(Categories<>'Color', Categories)</P><P></P><P>And, enable 'Suppress When Value Is Null' in dimension tab</P></BODY></HTML> Fri, 28 Sep 2018 05:17:35 GMT https://community.qlik.com/t5/QlikView/exclude-categories-from-column/m-p/116532#M1292438 tresB 2018-09-28T05:17:35Z