topic Re: Dimension based on multiple criteria / values in other dimensions in QlikView https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620274#M228346 <HTML><HEAD></HEAD><BODY><P>Example for you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Let me know if it helps.</P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 25 Apr 2014 10:10:55 GMT 2014-04-25T10:10:55Z Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620271#M228343 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I want to create a New dimension called&nbsp; <STRONG>Freight TYPE</STRONG>&nbsp; with two values : Dedicated and MIXED.</P><P>Dedicated freight&nbsp; is any freight with only one type of Customer Group under Section TYPE<STRONG><BR />“ OUT”&nbsp; </STRONG>, so that: Freight 1: would be classified as mixed and Freight 2 as dedicated.</P><P></P><P>The end result would be:</P><P></P><P><STRONG>Customer</STRONG><BR /><STRONG>Group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Freight.TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cost</STRONG></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mixed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp; </P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dedicated&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P></P><P></P><P>Data looks somewhat like below:</P><P></P><P>Freight #&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Section.Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer Group1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COST</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>1 OUT B 100</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>I was&nbsp; trying different ways in calculated dimension combaining&nbsp; AGGR, TOTAL, Count(Distinct) and iF</P><P>But none of it worked.</P><P></P><P></P><P>Big thanks in advance to anyone who can solve it !</P></BODY></HTML> Fri, 25 Apr 2014 09:41:07 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620271#M228343 Anonymous 2014-04-25T09:41:07Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620272#M228344 <HTML><HEAD></HEAD><BODY><P>Adam,</P><P></P><P>may you provide qvw with sample data?</P><P></P><P>pozdrawiam</P><P>Darek</P></BODY></HTML> Fri, 25 Apr 2014 09:49:06 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620272#M228344 2014-04-25T09:49:06Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620273#M228345 <HTML><HEAD></HEAD><BODY><P>Ok, i can see data, give me a moment <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 25 Apr 2014 09:54:09 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620273#M228345 2014-04-25T09:54:09Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620274#M228346 <HTML><HEAD></HEAD><BODY><P>Example for you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Let me know if it helps.</P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 25 Apr 2014 10:10:55 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620274#M228346 2014-04-25T10:10:55Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620275#M228347 <HTML><HEAD></HEAD><BODY><P>As per your requirement logic It looks likes one Customer Group can be either Dedicated or Mixed based on the Section type of the Freight#.</P><P>From the Data given below it looks like</P><P>Group A for Freight 1 is Mixed as the Freight 1 is having two records with Section Type as OUT. however</P><P>Group A for Freight 2 is Dedicated as there is only one record with Section Type as OUT.</P><P>I've attached an example where the Freight Type is calculated at&nbsp; a script level.</P><P></P><P>Freight #&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Section.Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer Group1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COST</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P></BODY></HTML> Fri, 25 Apr 2014 10:27:22 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620275#M228347 sudeepkm 2014-04-25T10:27:22Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620276#M228348 <HTML><HEAD></HEAD><BODY><P>Dariusz,</P><P></P><P>Thanks, but would it be possible to incorporate <STRONG>distinct</STRONG> after count?</P><P></P><P>The real data is much more complex as&nbsp; there are more dimensions relating to the customer group such as customer point. There are many drop points for one customer group relating to particular&nbsp; freight . So&nbsp; I need to be able to use distinct somehow.</P></BODY></HTML> Fri, 25 Apr 2014 10:57:12 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620276#M228348 Anonymous 2014-04-25T10:57:12Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620277#M228349 <HTML><HEAD></HEAD><BODY><P>Sudeep,</P><P>I will check this and will let you know shortly.</P></BODY></HTML> Fri, 25 Apr 2014 10:58:19 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620277#M228349 Anonymous 2014-04-25T10:58:19Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620278#M228350 <HTML><HEAD></HEAD><BODY><P>Of course <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> i'am sorry ...</P><P></P><P>use:</P><P></P><P>=aggr(if(count( DISTINCT total &lt;Group&gt; Freight)=1,'Dedic','Mix'),Group)</P></BODY></HTML> Fri, 25 Apr 2014 11:05:44 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620278#M228350 2014-04-25T11:05:44Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620279#M228351 <HTML><HEAD></HEAD><BODY><P>Dariusz,</P><P>But we are counting only groups for&nbsp;&nbsp; section type- 'OUT' ( another dimension).</P><P>Could you add that condition?</P><P></P><P><SPAN style="font-size: 8pt;">I put below in the expression in my model, and all is returned as dedicated: Did I get it right?</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerGroup</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">FreightNum</SPAN><SPAN style="font-size: 8pt;"> &amp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Freights_Plachta.SectionType</SPAN><SPAN style="font-size: 8pt;">='OUT')=1,'Dedic','Mix'),</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerGroup</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Fri, 25 Apr 2014 11:33:24 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620279#M228351 Anonymous 2014-04-25T11:33:24Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620280#M228352 <HTML><HEAD></HEAD><BODY><P>Adam,</P><P>Please, privide qvw with your data model and sample data</P><P>Regards</P><P>Darek</P><P>25-04-2014 13:34 użytkownik "Adam Safita" &lt;qcwebmaster@qlik.com&gt;</P><P>napisał:</P><P></P><BLOCKQUOTE level="1"><P> Qlik Community &lt;http://community.qlik.com/&gt; Dimension based on</P><P>multiple criteria / values in other dimensions</P><P></P><P>reply from Adam Safita&lt;http://community.qlik.com/people/asafita77?et=watches.email.thread&gt;in *App</P><P>Development* - View the full discussion&lt;http://community.qlik.com/message/516060?et=watches.email.thread#516060&gt;</P></BLOCKQUOTE><P></P></BODY></HTML> Fri, 25 Apr 2014 11:57:53 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620280#M228352 2014-04-25T11:57:53Z Re: Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620281#M228353 <HTML><HEAD></HEAD><BODY><P>look on v1 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I changed a little your oryginal field names. This is why sharing sample is the best option.</P><P></P><P>let me know if it helps.</P><P></P><P>pozdrawiam serdecznie</P><P>Darek</P></BODY></HTML> Fri, 25 Apr 2014 12:23:56 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620281#M228353 2014-04-25T12:23:56Z Re: Dimension based on multiple criteria / values in other dimensions https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620282#M228354 <HTML><HEAD></HEAD><BODY><P>Sudeep,</P><P>Big Thanks&nbsp; for your help !!!</P><P>Your solution&nbsp; works great</P></BODY></HTML> Mon, 05 May 2014 14:07:40 GMT https://community.qlik.com/t5/QlikView/Dimension-based-on-multiple-criteria-values-in-other-dimensions/m-p/620282#M228354 Anonymous 2014-05-05T14:07:40Z