Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would doing in the script be an option like:
Load
Filter1,
IsText(Filter1) as Flag
?