Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional display of values

Hello everyone,

New Query:

          I have created two multi boxes of 'Year' (it can also be a list box) and I want to make independent selections from both which I achieved by creating alternate states.

However now the issues:

          If I choose Year = 2005 in multibox 1 then i want that the values to be displayed on multibox 2 should be greater than 2005.

The values to be displayed in Multibox 2 should be always greater than the selected field value in Multibox 1.

1 Solution

Accepted Solutions
Not applicable
Author

Got it.

Chk this.

Thanks,

Prabhu

View solution in original post

11 Replies
alexandros17
Partner - Champion III
Partner - Champion III

You may add a trigger to the field (Settings -> document properties -> triggers)

Not applicable
Author

Can you please elaborate..

ashwanin
Specialist
Specialist

Alessandros suggestion will work for you. Please use this in your qvw.

Not applicable
Author

Hi,

Pls go through the attached qvw.

Trigger is set up in Document Properties.

Thanks,

Prabhu

Not applicable
Author

ok I will try to explain further...

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 listboxes should display values greater than 2005 and they should also be available for selection.

if i want to calculate Difference of Sales(per say) of 2005 and 2008 so i would select the years separately from two list boxes and I also need to make sure that the second listbox only displays values greater than the selected value in first listbox.

I hope this explains the issue

Not applicable
Author

Did you go through the attached qvw?

I believe what you expect is implemented.

Thanks,

Prabhu

Not applicable
Author

The value in the second list box keeps changing... I want to make a selection in the second listbox as well. The only criteria is that the user should not be able to see the year values less than the first selection

Not applicable
Author

Got it.

Chk this.

Thanks,

Prabhu

Not applicable
Author

Ya it is... Thank you so much