topic Conditional display of values in multiboxes in QlikView

Conditional display of values in multiboxes

Mon, 31 Mar 2014 10:18:38 GMT

There are two listboxes of 'YEAR'.

Suppose first listbox is in state 1 and second listbox is in state 2

now if i select 2005 in first listbox I want that second listbox should display values greater than 2005 and they should also be available for selection.

If i want to calculate the difference of Sales(per say) between year 2005 and 2008

Then i should be able to select 2005 from first listbox and 2008 from second. also if i select 2005 in first listbox, the values appearing in second listbox should start from 2006.

Help...

Re: Conditional display of values in multiboxes

MK_QSL — Mon, 31 Mar 2014 10:24:12 GMT

List Box 1

Field

Year

List Box 2

Use below expression instead of Field Year

=IF(Year>GetFieldSelections(Year),Year)

Re: Conditional display of values in multiboxes

tresB — Mon, 31 Mar 2014 10:24:24 GMT

Paromita,

Please don't create multiple threads for same query. Conditional display of values . The discussion in the thread already there would help others to figure out what exactly you want; therefore it gives you better chance there to be answered.