topic Display only non-null columns. in QlikView https://community.qlik.com/t5/QlikView/Display-only-non-null-columns/m-p/282757#M105105 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a large excel table with many columns.</P><P>My key is a unique number and every column marked with 1 or null.</P><P></P><P>I like to display for each number only the columns that arenot null.</P><P></P><P>Any idea for a good solution how this can be done?</P><P>I will probably will find a complex way to do so, but until Iwill, I like to get some input from you,</P><P>Who this can be done efficiently</P><P></P><P></P><P>Thanks in advance,</P><P>T.</P><P></P><P>Enclosed is excel file with some data as example, it includeonly 20 columns, in the original file I have many many more.</P></BODY></HTML> Tue, 06 Dec 2011 14:37:45 GMT 2011-12-06T14:37:45Z Display only non-null columns. https://community.qlik.com/t5/QlikView/Display-only-non-null-columns/m-p/282757#M105105 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a large excel table with many columns.</P><P>My key is a unique number and every column marked with 1 or null.</P><P></P><P>I like to display for each number only the columns that arenot null.</P><P></P><P>Any idea for a good solution how this can be done?</P><P>I will probably will find a complex way to do so, but until Iwill, I like to get some input from you,</P><P>Who this can be done efficiently</P><P></P><P></P><P>Thanks in advance,</P><P>T.</P><P></P><P>Enclosed is excel file with some data as example, it includeonly 20 columns, in the original file I have many many more.</P></BODY></HTML> Tue, 06 Dec 2011 14:37:45 GMT https://community.qlik.com/t5/QlikView/Display-only-non-null-columns/m-p/282757#M105105 2011-12-06T14:37:45Z