topic Re: Filter functions in QlikView https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106617#M1247862 <HTML><HEAD></HEAD><BODY><P>AFAIK there is no official documentation available. If I remember correctly than there are a short chapter in two QlikView books which describe some of the advance transforming features which are available within the QlikView load-wizard (I don't know if it's available in the Sense wizards, too).</P><P></P><P>In your case it means that there is a string-condition applied which replaced NULL's but I'm not sure if they are replaced with 1 or top respectively if it will be applied for the first row or column ... If you look within the above mentioned books you will get some hints about order and meaning of the parameter. Also you could use the above wizard to check it out with some reverse engineering approaches.</P><P></P><P>But honestly I wouldn't do it because there is nothing which couldn't be reached with "normal" where-clauses or other transforming steps.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 07 Sep 2018 12:43:03 GMT marcus_sommer 2018-09-07T12:43:03Z Filter functions https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106616#M1247858 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone explain me the below expression?</P><P></P><P>(biff, embedded labels, table is [Sheet1$], <STRONG style="color: #666699;">filters(</STRONG></P><P><SPAN style="color: #666699;"><STRONG>Replace(1, top, StrCnd(null)).</STRONG></SPAN></P><P></P><P><SPAN style="color: #000000;">and where can I study about the functions (<SPAN style="color: #666699;"><STRONG>Replace(1, top, StrCnd(null)).</STRONG></SPAN>) with filters conditions.</SPAN></P><P></P><P><SPAN style="color: #000000;">I need to use it in qlik sense. </SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106616#M1247858 jeevays7 2026-01-26T18:19:17Z Re: Filter functions https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106617#M1247862 <HTML><HEAD></HEAD><BODY><P>AFAIK there is no official documentation available. If I remember correctly than there are a short chapter in two QlikView books which describe some of the advance transforming features which are available within the QlikView load-wizard (I don't know if it's available in the Sense wizards, too).</P><P></P><P>In your case it means that there is a string-condition applied which replaced NULL's but I'm not sure if they are replaced with 1 or top respectively if it will be applied for the first row or column ... If you look within the above mentioned books you will get some hints about order and meaning of the parameter. Also you could use the above wizard to check it out with some reverse engineering approaches.</P><P></P><P>But honestly I wouldn't do it because there is nothing which couldn't be reached with "normal" where-clauses or other transforming steps.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 07 Sep 2018 12:43:03 GMT https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106617#M1247862 marcus_sommer 2018-09-07T12:43:03Z Re: Filter functions https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106618#M1247864 <HTML><HEAD></HEAD><BODY><P>Thank you marcus.</P></BODY></HTML> Fri, 07 Sep 2018 13:50:49 GMT https://community.qlik.com/t5/QlikView/Filter-functions/m-p/106618#M1247864 jeevays7 2018-09-07T13:50:49Z