topic Re: dimensions in QlikView https://community.qlik.com/t5/QlikView/dimensions/m-p/538#M793463 <HTML><HEAD></HEAD><BODY><P>I think it maybe something with exception cause when I do it manually it works good</P></BODY></HTML> Mon, 15 Jan 2018 08:10:33 GMT denis115 2018-01-15T08:10:33Z dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/533#M793458 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have list of all clients and list of a part of clients that are included in "all clients"</P><P>I need to see in table clients that are not included in second list of clients</P><P>I think its like "allclients-clients2" but it doesnt worked.</P><P>Help please&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/533#M793458 denis115 2020-11-25T16:16:04Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/534#M793459 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>Load * inline [</P><P>SomeClients</P><P>1</P><P>3</P><P>];</P><P></P><P></P><P>Load *,ClientsAll as ClientMissing</P><P></P><P> Inline [</P><P>ClientsAll</P><P>1</P><P>2</P><P>3</P><P>4</P><P>5</P><P>6</P><P>] where <STRONG>not Exists</STRONG>(SomeClients,ClientsAll);</P></BODY></HTML> Mon, 15 Jan 2018 07:46:33 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/534#M793459 tresB 2018-01-15T07:46:33Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/535#M793460 <HTML><HEAD></HEAD><BODY><P>yes&nbsp; but I need to show it in a chart by expression</P></BODY></HTML> Mon, 15 Jan 2018 07:50:06 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/535#M793460 denis115 2018-01-15T07:50:06Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/536#M793461 <HTML><HEAD></HEAD><BODY><P>Could you provide a sample qvw? Because the solution could vary based on the data model. </P></BODY></HTML> Mon, 15 Jan 2018 07:52:30 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/536#M793461 tresB 2018-01-15T07:52:30Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/537#M793462 <HTML><HEAD></HEAD><BODY><P>It will take a lot of time cause Im using section access.</P><P>For example I have an excel file that have as dimension CLIENT10,CLIENTID, 1 and when I select 1 I see all clients that have discount 10% but I need also to see near in a chart all clients that are not included in this list of clients that have discount 10% </P></BODY></HTML> Mon, 15 Jan 2018 08:00:59 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/537#M793462 denis115 2018-01-15T08:00:59Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/538#M793463 <HTML><HEAD></HEAD><BODY><P>I think it maybe something with exception cause when I do it manually it works good</P></BODY></HTML> Mon, 15 Jan 2018 08:10:33 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/538#M793463 denis115 2018-01-15T08:10:33Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/539#M793464 <HTML><HEAD></HEAD><BODY><P>Try using the following expression to see all clients excluded in a text box.</P><P>=Concat(Distinct {&lt;Client=<STRONG>e</STRONG>(Client)&gt;} <SPAN style="font-size: 13.3333px;">Client&nbsp; , ','</SPAN>)</P></BODY></HTML> Mon, 15 Jan 2018 08:11:26 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/539#M793464 tresB 2018-01-15T08:11:26Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/540#M793465 <HTML><HEAD></HEAD><BODY><P>it show same things as simple list box</P></BODY></HTML> Mon, 15 Jan 2018 08:16:08 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/540#M793465 denis115 2018-01-15T08:16:08Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/541#M793466 <HTML><HEAD></HEAD><BODY><P>Could you share screen shots of the output, selection and expression you are using?</P></BODY></HTML> Mon, 15 Jan 2018 08:37:02 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/541#M793466 tresB 2018-01-15T08:37:02Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/542#M793467 <HTML><HEAD></HEAD><BODY><P>expresion is =</P><P></P><P><SPAN style="color: #ff8000; font-size: 8pt; text-decoration: underline;"><STRONG>(</STRONG></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">SUMI</SPAN><SPAN style="font-size: 8pt;">)-</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">SUMRETURN</SPAN><SPAN style="font-size: 8pt;">)</SPAN><STRONG style=": ; color: #ff8000; font-size: 8pt; text-decoration: underline;">) </STRONG></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/190058_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190057_pastedImage_0.png" style="width: 349px; height: 224px; float: left;" /></P></BODY></HTML> Mon, 15 Jan 2018 08:47:32 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/542#M793467 denis115 2018-01-15T08:47:32Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/543#M793468 <HTML><HEAD></HEAD><BODY><P>Hi Cucuta,</P><P></P><P>Use not exists() in this case.</P><P></P><P>Regards</P><P>KAmal</P></BODY></HTML> Mon, 15 Jan 2018 09:38:41 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/543#M793468 kamalqlik 2018-01-15T09:38:41Z Re: dimensions https://community.qlik.com/t5/QlikView/dimensions/m-p/544#M793469 <HTML><HEAD></HEAD><BODY><P>A sample to investigate and try on - would help me try further.</P></BODY></HTML> Mon, 15 Jan 2018 09:41:57 GMT https://community.qlik.com/t5/QlikView/dimensions/m-p/544#M793469 tresB 2018-01-15T09:41:57Z