topic Dimension with conditional in QlikView https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987000#M336606 <HTML><HEAD></HEAD><BODY><P>I have 2 tables, parts and products. but they are not linked, part-nbr is same notation as product-nbr. I have a chart with fields from parts and I want to bring one of the attributes of the product table. but when I do this it creates a lot extra rows with all the products not included in the part table, how can I just populate the attribute for the current parts in the table? How is the statement <SPAN style="font-size: 10pt; line-height: 1.5em;">for a conditional? or is there any other way I can do this.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Parts-Nbr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Desc</STRONG></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Products-Nbr&nbsp;&nbsp;&nbsp;&nbsp; Width</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">5879&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .36</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3548</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .35</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .58</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">8542&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .87</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3698&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .45</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .85</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">I want my output to be:</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><STRONG>Parts-Nbr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Desc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Width</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11awg&nbsp;&nbsp;&nbsp;&nbsp; .12&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22awg&nbsp;&nbsp;&nbsp;&nbsp; .35</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30awg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .87</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .45</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78awg&nbsp;&nbsp;&nbsp;&nbsp; .85</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">This is just an example there are so many other fields and tables. I can not rename the fields.</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Thank you.<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P></BODY></HTML> Fri, 02 Oct 2015 13:18:33 GMT hildacgg 2015-10-02T13:18:33Z Dimension with conditional https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987000#M336606 <HTML><HEAD></HEAD><BODY><P>I have 2 tables, parts and products. but they are not linked, part-nbr is same notation as product-nbr. I have a chart with fields from parts and I want to bring one of the attributes of the product table. but when I do this it creates a lot extra rows with all the products not included in the part table, how can I just populate the attribute for the current parts in the table? How is the statement <SPAN style="font-size: 10pt; line-height: 1.5em;">for a conditional? or is there any other way I can do this.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Parts-Nbr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Desc</STRONG></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78awg</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>Products-Nbr&nbsp;&nbsp;&nbsp;&nbsp; Width</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">5879&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .36</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3548</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .21</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .35</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .58</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">8542&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .87</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3698&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .45</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .85</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">I want my output to be:</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><STRONG>Parts-Nbr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Desc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Width</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11awg&nbsp;&nbsp;&nbsp;&nbsp; .12&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">2280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22awg&nbsp;&nbsp;&nbsp;&nbsp; .35</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">3020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30awg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .87</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4560&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .45</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">4512&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45awg&nbsp;&nbsp;&nbsp;&nbsp; .12</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7854&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78awg&nbsp;&nbsp;&nbsp;&nbsp; .85</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">This is just an example there are so many other fields and tables. I can not rename the fields.</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">Thank you.<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P></BODY></HTML> Fri, 02 Oct 2015 13:18:33 GMT https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987000#M336606 hildacgg 2015-10-02T13:18:33Z Re: Dimension with conditional https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987001#M336607 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>please try this on. it is help full for you.</P><P></P><P>T1:</P><P>load * Inline&nbsp;&nbsp; [</P><P>Parts-Nbr,Desc</P><P>1120 ,11awg</P><P>2280 ,22awg</P><P>3020 ,30awg</P><P>4578 ,45awg</P><P>4560 ,45awg</P><P>4512 ,45awg</P><P>7854 ,78awg</P><P>];</P><P></P><P></P><P>T2:</P><P>mapping load * Inline [</P><P></P><P></P><P>Products-Nbr,Width</P><P>1120,.12</P><P>5879,.36</P><P>3548,.21</P><P>2280,.35</P><P>3020,.58</P><P>8542,.65</P><P>4578,.87</P><P>3698,.65</P><P>4560,.45</P><P>4512,.12</P><P>7854,.85</P><P>];</P><P></P><P></P><P>T3:</P><P>load</P><P>[Parts-Nbr],</P><P>ApplyMap('T2',[Parts-Nbr]) as width, </P><P>Desc</P><P>Resident T1; </P><P>DROP Table T1;</P></BODY></HTML> Fri, 02 Oct 2015 16:48:33 GMT https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987001#M336607 maniram23 2015-10-02T16:48:33Z Re: Dimension with conditional https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987002#M336608 <HTML><HEAD></HEAD><BODY><P>Thank you, I figured it out already. I added a column for part-number in the Product table.</P><P></P><P>Thanks a lot!</P></BODY></HTML> Fri, 02 Oct 2015 18:17:52 GMT https://community.qlik.com/t5/QlikView/Dimension-with-conditional/m-p/987002#M336608 hildacgg 2015-10-02T18:17:52Z