topic Re: Display all values for a selected division in QlikView https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990855#M971610 <HTML><HEAD></HEAD><BODY><P>Depends on how your expression is written but usually 1 will stops all filtering</P><P>Like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>{1} </STRONG></SPAN><EM>Value</EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)/SUM(<STRONG>{1}</STRONG> <EM>Value</EM>)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(19 articles)</A></P></BODY></HTML> Mon, 07 Sep 2015 22:14:57 GMT robert_mika 2015-09-07T22:14:57Z Display all values for a selected division https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990853#M971608 <HTML><HEAD></HEAD><BODY><P>Hi Everybody,</P><P></P><P>I have created this chart which displays values for the time spent by a territory manager(TM) in-field. The values of this chart changes the number of TM's displayed when another chart has null values for certain TM's.</P><P>Is there a way to stop the chart keeping its display static??</P><P>Image shown below.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 07 Sep 2015 15:47:10 GMT https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990853#M971608 snehamahaveer 2015-09-07T15:47:10Z Re: Display all values for a selected division https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990854#M971609 <HTML><HEAD></HEAD><BODY><P>Can you explain better the problem, please.</P></BODY></HTML> Mon, 07 Sep 2015 17:06:28 GMT https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990854#M971609 ecolomer 2015-09-07T17:06:28Z Re: Display all values for a selected division https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990855#M971610 <HTML><HEAD></HEAD><BODY><P>Depends on how your expression is written but usually 1 will stops all filtering</P><P>Like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>{1} </STRONG></SPAN><EM>Value</EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)/SUM(<STRONG>{1}</STRONG> <EM>Value</EM>)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: 'comic sans ms', sans-serif;">Feeling Qlikngry?</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="8342" data-objecttype="102" href="https://community.qlik.com/docs/DOC-8342" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">How To /Missing Manual(19 articles)</A></P></BODY></HTML> Mon, 07 Sep 2015 22:14:57 GMT https://community.qlik.com/t5/QlikView/Display-all-values-for-a-selected-division/m-p/990855#M971610 robert_mika 2015-09-07T22:14:57Z