topic Calulated Dimension filter in QlikView https://community.qlik.com/t5/QlikView/Calulated-Dimension-filter/m-p/1203232#M387067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help? I have a field where sometimes there is a reference and sometimes it is null.</P><P></P><P>I have created a 'calculated dimension' that shows if the field has a reference then in says 'CATALOG' and if the field is null then 'NONCATALOG'.</P><P></P><P>This works ok but I am unable to filter on my new field in straight table, 'NONCATALOG' is greyed out?</P><P></P><P>Any help would be much appreciated.</P><P></P><P>thanks</P></BODY></HTML> Tue, 01 Nov 2016 17:15:15 GMT 2016-11-01T17:15:15Z Calulated Dimension filter https://community.qlik.com/t5/QlikView/Calulated-Dimension-filter/m-p/1203232#M387067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help? I have a field where sometimes there is a reference and sometimes it is null.</P><P></P><P>I have created a 'calculated dimension' that shows if the field has a reference then in says 'CATALOG' and if the field is null then 'NONCATALOG'.</P><P></P><P>This works ok but I am unable to filter on my new field in straight table, 'NONCATALOG' is greyed out?</P><P></P><P>Any help would be much appreciated.</P><P></P><P>thanks</P></BODY></HTML> Tue, 01 Nov 2016 17:15:15 GMT https://community.qlik.com/t5/QlikView/Calulated-Dimension-filter/m-p/1203232#M387067 2016-11-01T17:15:15Z Re: Calulated Dimension filter https://community.qlik.com/t5/QlikView/Calulated-Dimension-filter/m-p/1203233#M387068 <HTML><HEAD></HEAD><BODY><P>I guess null can not be filtered. The work around this would be to convert nulls into NONCATALOG on the back end of the application and then it should allow you to make selections.</P></BODY></HTML> Tue, 01 Nov 2016 17:55:22 GMT https://community.qlik.com/t5/QlikView/Calulated-Dimension-filter/m-p/1203233#M387068 sunny_talwar 2016-11-01T17:55:22Z