Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to only show records that have specific values

Hello all,

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?

Data Example:

Header 1Header 2Header 3Project Requesting Office
A
B
C
A

Regards,

Myles

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

In the dimension tab set the suppress null values option

View solution in original post

4 Replies
stigchel
Partner - Master
Partner - Master

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

Only({<MyField={'A','C'}>} MyField)

or as Dimension

Aggr(Only({<MyField={'A','C'}>} MyField),MyField)

Not applicable
Author

Hi Piet,

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.

Regards,

Myles

stigchel
Partner - Master
Partner - Master

In the dimension tab set the suppress null values option

Not applicable
Author

Thanks Piet.

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!


Best Regards,

Myles