topic Re: Alternate States in QlikView https://community.qlik.com/t5/QlikView/Alternate-States/m-p/1297971#M404909 <HTML><HEAD></HEAD><BODY><P>Can you do this, May be?</P><P></P><P><STRONG>Sample:</STRONG></P><P><STRONG>LOAD [Parent Component], </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; [Child Component]</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-message-small" data-containerid="2051" data-containertype="14" data-objectid="1271301" data-objecttype="2" href="https://community.qlik.com/message/1271301#1271301">https://community.qlik.com/message/1271301</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P><STRONG>LOAD [Parent Component], Concat('(' &amp; [Child Component] &amp; ')','/') as Red Resident Sample Group By [Parent Component];</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164031_Capture.PNG" style="height: 126px; width: 620px;" /></P></BODY></HTML> Fri, 19 May 2017 11:44:39 GMT Anil_Babu_Samineni 2017-05-19T11:44:39Z Alternate States https://community.qlik.com/t5/QlikView/Alternate-States/m-p/1297970#M404908 <HTML><HEAD></HEAD><BODY><P>I have the below set of data</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 226px;"><TBODY><TR><TD height="19" style="border: 0.5pt solid black; border-image: none; background-color: #e1e1e1;" width="117"><SPAN style="color: #000000; font-family: Segoe UI;">Parent Component</SPAN></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: black; background-color: #e1e1e1;" width="109"><SPAN style="color: #000000; font-family: Segoe UI;">Child Component</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #fff2cc;"><SPAN style="color: #000000; font-family: Segoe UI;">N366499</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: red black black red; background-color: #f8cbad;"><SPAN style="color: #ff0000; font-family: Segoe UI;">444793-00</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #fff2cc;"><SPAN style="color: #000000; font-family: Segoe UI;">N366499</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: red black black red; background-color: #ffc000;"><SPAN style="color: #ff0000; font-family: Segoe UI;">30301914-01</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #c6e0b4;"><SPAN style="color: #000000; font-family: Segoe UI;">N146358</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: red black black red; background-color: #f8cbad;"><SPAN style="color: #ff0000; font-family: Segoe UI;">444793-00</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #c6e0b4;"><SPAN style="color: #000000; font-family: Segoe UI;">N146358</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: red black black red; background-color: #ffc000;"><SPAN style="color: #ff0000; font-family: Segoe UI;">30301914-01</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #c6e0b4;"><SPAN style="color: #000000; font-family: Segoe UI;">N146358</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #5b9bd5;"><SPAN style="color: #000000; font-family: Segoe UI;">30301910-00UM</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #b4c6e7;"><SPAN style="color: #000000; font-family: Segoe UI;">N147481</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #f8cbad;"><SPAN style="color: #000000; font-family: Segoe UI;">444793-00</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #b4c6e7;"><SPAN style="color: #000000; font-family: Segoe UI;">N147481</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #ffc000;"><SPAN style="color: #000000; font-family: Segoe UI;">30301914-01</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black; background-color: #b4c6e7;"><SPAN style="color: #000000; font-family: Segoe UI;">N147481</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black; background-color: #5b9bd5;"><SPAN style="color: #000000; font-family: Segoe UI;">30301910-00UM</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>I have created two list boxes - Parent Component / Child Component</P><P>When I select parent component&nbsp; <SPAN style="color: #000000; font-family: Segoe UI;">N366499</SPAN> /&nbsp; <SPAN style="color: #000000; font-family: Segoe UI;">N146358</SPAN> , the intersection values should show in the child component box&nbsp; ( <SPAN style="color: #ff0000; font-family: Segoe UI;">444793-00</SPAN> / <SPAN style="color: #ff0000; font-family: Segoe UI;">30301914-01</SPAN> )</P><P></P><P>Please provide inputs</P></BODY></HTML> Fri, 19 May 2017 06:08:59 GMT https://community.qlik.com/t5/QlikView/Alternate-States/m-p/1297970#M404908 parul_mehta 2017-05-19T06:08:59Z Re: Alternate States https://community.qlik.com/t5/QlikView/Alternate-States/m-p/1297971#M404909 <HTML><HEAD></HEAD><BODY><P>Can you do this, May be?</P><P></P><P><STRONG>Sample:</STRONG></P><P><STRONG>LOAD [Parent Component], </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; [Child Component]</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-message-small" data-containerid="2051" data-containertype="14" data-objectid="1271301" data-objecttype="2" href="https://community.qlik.com/message/1271301#1271301">https://community.qlik.com/message/1271301</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P><STRONG>LOAD [Parent Component], Concat('(' &amp; [Child Component] &amp; ')','/') as Red Resident Sample Group By [Parent Component];</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164031_Capture.PNG" style="height: 126px; width: 620px;" /></P></BODY></HTML> Fri, 19 May 2017 11:44:39 GMT https://community.qlik.com/t5/QlikView/Alternate-States/m-p/1297971#M404909 Anil_Babu_Samineni 2017-05-19T11:44:39Z