topic Re: Show dimension even when count() expression is 0 in QlikView https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411344#M153158 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 06 Feb 2013 18:19:30 GMT 2013-02-06T18:19:30Z Show dimension even when count() expression is 0 https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411342#M153156 <HTML><HEAD></HEAD><BODY><P>I'm working with 4 graphs, each being filtered by a job.&nbsp; I want to count the status, specific to those jobs by filtering on [Job Title].</P><P>All panels should display the same dimensions.. They're not.&nbsp; Here's how I filtered them...</P><P></P><P>Dimension: [Workflow Status]</P><P>Expression: count( {$&lt;[Job : Title] = {'[job of interest etc]'}&gt;} [Workflow Status])</P><P></P><P><IMG alt="http://i45.tinypic.com/6j13ly.png" class="jive-image" src="http://i45.tinypic.com/6j13ly.png" /></P></BODY></HTML> Wed, 06 Feb 2013 18:15:19 GMT https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411342#M153156 2013-02-06T18:15:19Z Re: Show dimension even when count() expression is 0 https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411343#M153157 <HTML><HEAD></HEAD><BODY><P>On Presentation tab, uncheck "Suppress Zero Values".</P></BODY></HTML> Wed, 06 Feb 2013 18:18:17 GMT https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411343#M153157 Nicole-Smith 2013-02-06T18:18:17Z Re: Show dimension even when count() expression is 0 https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411344#M153158 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 06 Feb 2013 18:19:30 GMT https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411344#M153158 2013-02-06T18:19:30Z Re: Show dimension even when count() expression is 0 https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411345#M153159 <HTML><HEAD></HEAD><BODY><P>Try to uncheck "Supress zero values" and "Suppress missing" on tab Presentation</P></BODY></HTML> Wed, 06 Feb 2013 18:20:47 GMT https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411345#M153159 Anonymous 2013-02-06T18:20:47Z Re: Show dimension even when count() expression is 0 https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411346#M153160 <HTML><HEAD></HEAD><BODY><P>you can use </P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">GetPossibleCount</SPAN><SPAN style="font-size: 8pt;">([Workflow Status]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Wed, 06 Feb 2013 18:21:49 GMT https://community.qlik.com/t5/QlikView/Show-dimension-even-when-count-expression-is-0/m-p/411346#M153160 2013-02-06T18:21:49Z