topic Conditional Listbox View in QlikView

Conditional Listbox View

Anonymous — Fri, 16 Oct 2009 23:18:39 GMT

I have data as far back as 1998. I need to create a Fiscal Year listbox that only lists from 2006 forward.

Anonymous — Fri, 16 Oct 2009 23:19:25 GMT

PS: What how do I set the view to only show from 2006 forward?

Fri, 16 Oct 2009 23:31:28 GMT

I think you could do something like this:

=if(Year(Date)>='2006',Date,)

Sat, 17 Oct 2009 01:51:28 GMT

In ListBox - Columns, the very first option is to use an expression.

Use

=if(Year(Date) >= '2006', Year(Date))

Anonymous — Sat, 17 Oct 2009 02:36:39 GMT

I don't see ListBox - Columns. List box only gives me the ability to choose 1 field.

Sat, 17 Oct 2009 04:25:54 GMT

On the 'General' tab of the Listbox Properties, it's under Field <Expression>

Here you can put the expression.

Anonymous — Sat, 17 Oct 2009 04:39:21 GMT

Thank you Xena. I was able to enter the expression substituting Date for the field name FiscYear. I got no return values.

Anonymous — Sat, 17 Oct 2009 04:40:55 GMT

=if(FiscYear >= '2006', FiscYear)

I modified the expression to the above and it works. Thank you guys for all your assistance!