Discussion Board for collaboration on QlikView Scripting.
I have a Field in my dashboard that I would like to filter multiple strings of potential results.
I was thinking that the match function may be able to assist me here, but am I on the right track? If so, how would I go about only including records with A and C within a straight table?
Go to Solution.
In the dimension tab set the suppress null values option
In the script you can use match to load only records with these values, something like
load * from....where match(MyField,'A','C')>0
Alternatively in the front end, you can use an expression with MyField as Dimension
or as Dimension
I opted to use aggr as an expression. Is there a way to suppress those null values ("-")? This would return only the records in the straight table that matter me this particular ask.
I didn't think to use that because i thought that the aggr function would only work as an expression.
Thanks for helping me out with this again!