Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: I want to only show records that have specific values

In the dimension tab set the suppress null values option

4 Replies
stigchel
Not applicable

Re: I want to only show records that have specific values

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

Re: I want to only show records that have specific values

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
Not applicable

Re: I want to only show records that have specific values

In the dimension tab set the suppress null values option

Not applicable

Re: I want to only show records that have specific values

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