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

I want to only show records that have specific values

Thu, 26 Mar 2015 15:15:12 GMT

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 1	Header 2	Header 3	Project Requesting Office
			A
			B
			C
			A

Regards,

Myles

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

stigchel — Thu, 26 Mar 2015 15:38:26 GMT

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)

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

Thu, 26 Mar 2015 16:18:38 GMT

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

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

stigchel — Thu, 26 Mar 2015 16:36:01 GMT

In the dimension tab set the suppress null values option

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

Thu, 26 Mar 2015 16:53:10 GMT

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