topic Hide sheet for null field in QlikView https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689105#M249543 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P>I have two sheet,Sales and Finance, in sales I have data in fields, but in finance i have no data in fields. I want to hide the sheet for finance because its fields dont have data but when the field will get data that sheet will be shown</P><P>PFA to test</P></BODY></HTML> Thu, 09 Oct 2014 08:08:30 GMT 2014-10-09T08:08:30Z Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689105#M249543 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P>I have two sheet,Sales and Finance, in sales I have data in fields, but in finance i have no data in fields. I want to hide the sheet for finance because its fields dont have data but when the field will get data that sheet will be shown</P><P>PFA to test</P></BODY></HTML> Thu, 09 Oct 2014 08:08:30 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689105#M249543 2014-10-09T08:08:30Z Re: Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689106#M249544 <HTML><HEAD></HEAD><BODY><P>try this one, i have created a variable vCount that get the count of AA + BB + CC + DD, and in the sheet expression i set it to conditional where vCount &gt; 0</P></BODY></HTML> Thu, 09 Oct 2014 08:12:31 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689106#M249544 maleksafa 2014-10-09T08:12:31Z Re: Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689107#M249545 <HTML><HEAD></HEAD><BODY><P>I just attached a sample file but in real i have more than 50 fields then how is this possible to do</P></BODY></HTML> Thu, 09 Oct 2014 08:14:48 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689107#M249545 2014-10-09T08:14:48Z Re: Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689108#M249546 <HTML><HEAD></HEAD><BODY><P>Thanks anyway I got the solution</P></BODY></HTML> Thu, 09 Oct 2014 08:44:51 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689108#M249546 2014-10-09T08:44:51Z Re: Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689109#M249547 <HTML><HEAD></HEAD><BODY><P>can you share it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> ?</P></BODY></HTML> Thu, 09 Oct 2014 09:41:14 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689109#M249547 maleksafa 2014-10-09T09:41:14Z Re: Re: Hide sheet for null field https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689110#M249548 <HTML><HEAD></HEAD><BODY><P>Please find the attachment</P></BODY></HTML> Thu, 09 Oct 2014 10:29:14 GMT https://community.qlik.com/t5/QlikView/Hide-sheet-for-null-field/m-p/689110#M249548 2014-10-09T10:29:14Z