topic Adding two rows into single row in QlikView https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772430#M1032026 <HTML><HEAD></HEAD><BODY><P>we Have a data (N/A,n/a,1,2,3,4)Group1 (sum of N/A and (blank) rows)&nbsp; </P><P>we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .</P><P>=if(Queue like ('N/A'),'Group1',Queue)</P><P></P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76347_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/76348_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 27 Jan 2015 13:13:37 GMT 2015-01-27T13:13:37Z Adding two rows into single row https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772430#M1032026 <HTML><HEAD></HEAD><BODY><P>we Have a data (N/A,n/a,1,2,3,4)Group1 (sum of N/A and (blank) rows)&nbsp; </P><P>we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .</P><P>=if(Queue like ('N/A'),'Group1',Queue)</P><P></P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76347_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/76348_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 27 Jan 2015 13:13:37 GMT https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772430#M1032026 2015-01-27T13:13:37Z Re: Adding two rows into single row https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772431#M1032027 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76355_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/76356_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Here need to comine N/A and - as Group 1</P><P></P><P>we show only Group1 in qlikview (sum of two rows (N/A and (blank))) .</P><P>Have used like operator not getting desired output </P></BODY></HTML> Tue, 27 Jan 2015 13:29:44 GMT https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772431#M1032027 2015-01-27T13:29:44Z Re: Adding two rows into single row https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772432#M1032028 <HTML><HEAD></HEAD><BODY><P>- is the null symbol. Replace null values in your data with Group1 and N/A to get the desired result</P></BODY></HTML> Tue, 27 Jan 2015 13:33:43 GMT https://community.qlik.com/t5/QlikView/Adding-two-rows-into-single-row/m-p/772432#M1032028 giakoum 2015-01-27T13:33:43Z