https://community.qlik.com/t5/App-Development/Filter-not-showing-the-grey-selections/m-p/1999796#M82801 <P>I'm using the following for a filter in qlik sense</P> <P>Aggr(field &amp; ' ' &amp; COUNT(line_id),field) to show the field value and the number of lines in the fact table</P> <P>If I use only field, I can see my green selection plus the greyed out item</P> <P>With the expression i only see the green selection.&nbsp; The grey items do not appear.</P> <P>I was using the frequency count but its right justified and gets truncated.</P> <P>Seems like I was able to do this with qlikview.</P> <P>&nbsp;</P> Wed, 02 Nov 2022 18:44:06 GMT markperrone 2022-11-02T18:44:06Z https://community.qlik.com/t5/App-Development/Filter-not-showing-the-grey-selections/m-p/1999796#M82801 <P>I'm using the following for a filter in qlik sense</P> <P>Aggr(field &amp; ' ' &amp; COUNT(line_id),field) to show the field value and the number of lines in the fact table</P> <P>If I use only field, I can see my green selection plus the greyed out item</P> <P>With the expression i only see the green selection.&nbsp; The grey items do not appear.</P> <P>I was using the frequency count but its right justified and gets truncated.</P> <P>Seems like I was able to do this with qlikview.</P> <P>&nbsp;</P> Wed, 02 Nov 2022 18:44:06 GMT https://community.qlik.com/t5/App-Development/Filter-not-showing-the-grey-selections/m-p/1999796#M82801 markperrone 2022-11-02T18:44:06Z