Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Conditional display of values in multiboxes

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...

2 Replies

Re: Conditional display of values in multiboxes

List Box 1

Field

Year

List Box 2

Use below expression instead of Field Year

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

MVP
MVP

Re: Conditional display of values in multiboxes

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.

Community Browser