Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

List Box 1

Field

Year

List Box 2

Use below expression instead of Field Year

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

tresesco
MVP
MVP

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.