Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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

?