topic Qlikview filtering in QlikView https://community.qlik.com/t5/QlikView/Qlikview-filtering/m-p/590585#M1102010 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I am quite new to QlikView and still learning it. I've got several filters in my document. I would like to check whether filter text data isText or isNum. As i have several filters in the whole document and several boxes contain calculations so checking filter value in expressions in every box makes everything too messy. I was wondering if anyone could suggest a way for getting value of filter text.</P><P></P><P><SPAN style="text-decoration: underline;">Example:</SPAN></P><P></P><P><STRONG>Filter1:</STRONG></P><P>-North</P><P>-South</P><P>-East</P><P>-West</P><P></P><P><STRONG>Filter2:</STRONG></P><P>-2012</P><P>-2013</P><P>-2014</P><P></P><P>So here I have text and numbers in filter. For now I check one filter only with expression isText(Filter1) and it works only for that filter. But I need to check all filters. I was trying to go with something like isText(getCurrentSelections()) but it doesn't work.</P></BODY></HTML> Wed, 02 Apr 2014 08:50:41 GMT 2014-04-02T08:50:41Z Qlikview filtering https://community.qlik.com/t5/QlikView/Qlikview-filtering/m-p/590585#M1102010 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I am quite new to QlikView and still learning it. I've got several filters in my document. I would like to check whether filter text data isText or isNum. As i have several filters in the whole document and several boxes contain calculations so checking filter value in expressions in every box makes everything too messy. I was wondering if anyone could suggest a way for getting value of filter text.</P><P></P><P><SPAN style="text-decoration: underline;">Example:</SPAN></P><P></P><P><STRONG>Filter1:</STRONG></P><P>-North</P><P>-South</P><P>-East</P><P>-West</P><P></P><P><STRONG>Filter2:</STRONG></P><P>-2012</P><P>-2013</P><P>-2014</P><P></P><P>So here I have text and numbers in filter. For now I check one filter only with expression isText(Filter1) and it works only for that filter. But I need to check all filters. I was trying to go with something like isText(getCurrentSelections()) but it doesn't work.</P></BODY></HTML> Wed, 02 Apr 2014 08:50:41 GMT https://community.qlik.com/t5/QlikView/Qlikview-filtering/m-p/590585#M1102010 2014-04-02T08:50:41Z Re: Qlikview filtering https://community.qlik.com/t5/QlikView/Qlikview-filtering/m-p/590586#M1102011 <HTML><HEAD></HEAD><BODY><P>Would doing in the script be an option like:</P><P>Load&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Filter1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IsText(Filter1) as Flag</P><P></P><P>?</P></BODY></HTML> Wed, 02 Apr 2014 08:55:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-filtering/m-p/590586#M1102011 tresB 2014-04-02T08:55:04Z