topic Filter in List Box in QlikView

Filter in List Box

Wed, 20 Jun 2012 04:05:31 GMT

Hi All,

I have a question in report designing, hope anyone can give me a help.

In my raw data, for example, I have 5 years information. So, if I use field: [Year] in a List Box, this List Box will show 5 numbers(eg. 2008, 2009, 2010, 2011, 2012). However, if I only want to show 2 numbers in List Box (2011, 2012), how can I filter this field?

I know it can be done in Script, but I want to know how to achieve it in Properties or other place? Can anyone give me some advices?

Thanks.

Re: Filter in List Box

Wed, 20 Jun 2012 04:28:53 GMT

hi,

Yes you can do it in list box also.

open the list box properties,in the general tab you will see the drop down of field.

see the drop down list, in that their is an option written as "<Expression>".

Select "<Expression>" and write thr "=If(Year>2010,Year)" or any other expression.

Re: Filter in List Box

Wed, 20 Jun 2012 05:15:09 GMT

Yes, you are right! I cannot believe that I have't noticed this detailed and useful function. Thanks a lot for your help! ^_^