Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview filtering

Hello!

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.

Example:

Filter1:

-North

-South

-East

-West

Filter2:

-2012

-2013

-2014

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.

1 Reply
tresesco
MVP
MVP

Would doing in the script be an option like:

Load    

          Filter1,

          IsText(Filter1) as Flag

?