topic Re: Help me. in QlikView https://community.qlik.com/t5/QlikView/Help-me/m-p/481667#M180002 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please provide more information about how you would like to get the result table (ie what rules determine the contents)? Also do you want to do this in script or in the front end?</P><P></P><P>Without that information I can only guess what you are trying to do.</P><P></P><P>Jonathan</P></BODY></HTML> Tue, 05 Nov 2013 14:19:29 GMT jonathandienst 2013-11-05T14:19:29Z Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481666#M180001 <HTML><HEAD></HEAD><BODY><P>temp:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; BA, ITS, BC</P><P>&nbsp;&nbsp;&nbsp; BA1, ITS1, TIER0</P><P>&nbsp;&nbsp;&nbsp; BA1, ITS2, TIER1</P><P>&nbsp;&nbsp;&nbsp; BA2, ITS3, TIER1</P><P>&nbsp;&nbsp;&nbsp; BA3</P><P>];</P><P></P><P>i have this table . i want to make.</P><P></P><TABLE border="1" class="jiveBorder" height="87.77777767181396" style="border: 1px solid #000000; width: 207.77777767181396px; height: 76.77777767181396px;" width="205.77777767181396"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>BA</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>BC</STRONG></TH></TR><TR><TD style="padding: 2px;">BA1</TD><TD style="padding: 2px;">TIER0</TD></TR><TR><TD style="padding: 2px;">BA2</TD><TD style="padding: 2px;">TIER1</TD></TR><TR><TD style="padding: 2px;">BA3</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>PLEASE HELP ME TO SOLVE THE PROBLEM.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 05 Nov 2013 14:09:04 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481666#M180001 2013-11-05T14:09:04Z Re: Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481667#M180002 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please provide more information about how you would like to get the result table (ie what rules determine the contents)? Also do you want to do this in script or in the front end?</P><P></P><P>Without that information I can only guess what you are trying to do.</P><P></P><P>Jonathan</P></BODY></HTML> Tue, 05 Nov 2013 14:19:29 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481667#M180002 jonathandienst 2013-11-05T14:19:29Z Re: Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481668#M180003 <HTML><HEAD></HEAD><BODY><P>You have to try to explain well your problem because in this way the answer is:</P><P></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>temp:</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>LOAD * INLINE [</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; BA, BC</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; BA1, TIER0</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; BA2, TIER1</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>&nbsp;&nbsp;&nbsp; BA3</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>];</STRONG></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Gio</P></BODY></HTML> Tue, 05 Nov 2013 14:25:20 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481668#M180003 2013-11-05T14:25:20Z Re: Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481669#M180004 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>Temp:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; BA, ITS, BC</P><P>&nbsp;&nbsp;&nbsp; BA1, ITS1, TIER0</P><P>&nbsp;&nbsp;&nbsp; BA1, ITS2, TIER1</P><P>&nbsp;&nbsp;&nbsp; BA2, ITS3, TIER1</P><P>&nbsp;&nbsp;&nbsp; BA3</P><P>];</P><P></P><P></P><P>Load BA, FirstValue(BC) as BC Resident Temp</P><P>Group by BA;</P><P></P><P></P><P>DROP Table Temp;</P></BODY></HTML> Tue, 05 Nov 2013 14:36:41 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481669#M180004 MayilVahanan 2013-11-05T14:36:41Z Re: Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481670#M180005 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 05 Nov 2013 15:42:47 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481670#M180005 Clever_Anjos 2013-11-05T15:42:47Z Re: Help me. https://community.qlik.com/t5/QlikView/Help-me/m-p/481671#M180006 <HTML><HEAD></HEAD><BODY><P>Thank you buddy....&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 06 Nov 2013 13:04:07 GMT https://community.qlik.com/t5/QlikView/Help-me/m-p/481671#M180006 2013-11-06T13:04:07Z