topic Re: Load specific rows using expressions in QlikView https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261891#M397943 <HTML><HEAD></HEAD><BODY><P>Try like this in that case:</P><P></P><P><STRONG>If(Match(LEVEL2, '16.29', '16.30', '16.31'), LEVEL2, LEVEL1) as LEVEL4</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 02:55:04 GMT sunny_talwar 2017-01-31T02:55:04Z Load specific rows using expressions https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261888#M397940 <HTML><HEAD></HEAD><BODY><P>How do I load specific rows using expressions in qlikview? For example, I have 2 columns in my excel which are LEVEL1 and LEVEL2. I want to load the rows as Level4 rows.</P><P>Currently im doing something likw the code below to get 16.29, 16.31 and 16.30 from LEVEL2 and the rest of LEVEL1 to be loaded as LEVEL4.</P><P><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL2</SPAN><SPAN style="font-size: 8pt;"> = '16.29', </SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL2</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: #800000; font-size: 8pt;">LEVEL2</SPAN><SPAN style="font-size: 8pt;"> = '16.31', </SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL2</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: #800000; font-size: 8pt;">LEVEL2</SPAN><SPAN style="font-size: 8pt;"> = '16.30'</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL2</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL1</SPAN><SPAN style="font-size: 8pt;">))) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">LEVEL4</SPAN><SPAN style="font-size: 8pt;">, </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Is there a simpler way to do this? I need a simpler way because if i want to load more LEVEL2 specific rows, it will get complicated. Thanks</SPAN></P></BODY></HTML> Tue, 31 Jan 2017 02:29:01 GMT https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261888#M397940 2017-01-31T02:29:01Z Re: Load specific rows using expressions https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261889#M397941 <HTML><HEAD></HEAD><BODY><P>The Level3 length check is only when LEVEL2 = 16.30? or is it also for when LEVEL2 = 16.29 or 16.31?</P></BODY></HTML> Tue, 31 Jan 2017 02:39:19 GMT https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261889#M397941 sunny_talwar 2017-01-31T02:39:19Z Re: Load specific rows using expressions https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261890#M397942 <HTML><HEAD></HEAD><BODY><P>Im sorry. I have made the adjustments. There is no LEVEL3.</P></BODY></HTML> Tue, 31 Jan 2017 02:50:09 GMT https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261890#M397942 2017-01-31T02:50:09Z Re: Load specific rows using expressions https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261891#M397943 <HTML><HEAD></HEAD><BODY><P>Try like this in that case:</P><P></P><P><STRONG>If(Match(LEVEL2, '16.29', '16.30', '16.31'), LEVEL2, LEVEL1) as LEVEL4</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 02:55:04 GMT https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261891#M397943 sunny_talwar 2017-01-31T02:55:04Z Re: Load specific rows using expressions https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261892#M397944 <HTML><HEAD></HEAD><BODY><P>Thank you very much sir!</P></BODY></HTML> Tue, 31 Jan 2017 02:59:36 GMT https://community.qlik.com/t5/QlikView/Load-specific-rows-using-expressions/m-p/1261892#M397944 2017-01-31T02:59:36Z