topic Re: How do you filter out unwanted data after selecting the dimension? in QlikView

How do you filter out unwanted data after selecting the dimension?

Tue, 10 Sep 2013 03:39:13 GMT

Hi all,

I have a rather simple question which I would like to know the best way of doing it.

Let's say I want to create a multibox for a selection purpose. The dimension selected contains the below data.

How do I only want 2012 to 2013 data to appear in the multibox? Right not it shows everything for selection.

Thx!

INTAKE

JAN2010

JUL2010

JAN2011

JUL2011

JAN2012

JUL2012

JAN2013

JUL2013

JAN2014

JUL2014

JAN2015

JUL2015

Re: How do you filter out unwanted data after selecting the dimension?

tresB — Tue, 10 Sep 2013 04:17:33 GMT

You can create an expression instead of taking the field directly in the multibox. And put the expression accordingly, like:

If(Right(INTAKE,4)='2012' or Right(INTAKE,4)='2013' , INTAKE)

Re: How do you filter out unwanted data after selecting the dimension?

Tue, 10 Sep 2013 05:19:15 GMT

Hi,

You can also try this in the expression dialog box

=if(WildMatch(INTAKE,'*2012','*2013'),INTAKE).

PFA,

Thanks and Regards,

S.Amuthabharathi

Re: How do you filter out unwanted data after selecting the dimension?

er_mohit — Tue, 10 Sep 2013 05:43:55 GMT

Try this

=pick(Match(INTAKE,'*2012','*2013'),'2012','2013') .

Re: How do you filter out unwanted data after selecting the dimension?

Tue, 10 Sep 2013 06:43:46 GMT

Hi,

Instead of using the dimension directly, you can create an expression & use it in the multibox. The expression can be :

=IF(Right (INTAKE,4) = '2012', INTAKE,

IF (Right (INTAKE,4) = '2013', INTAKE))

This is just one way to write the expression, there can be many other ways to write the expression to achieve the result you want. The key is, just write an expression instead of using the dimesnion column directly.

Hope this helps!