topic Button for next value from the ListBox in QlikView

Button for next value from the ListBox

mschatt — Thu, 01 Dec 2016 16:17:45 GMT

Hello, Is it possible to make a "Next" button to time time field? In example: I have listbox and there is: 8:00 9:00 10:00 11:00 I have selected 8:00, and when I click "Next" button it will change to 9:00. Thanks for all hints.

Re: Button for next value from the ListBox

rubenmarin — Thu, 01 Dec 2016 16:35:56 GMT

Hi Michal, you can try with an action that selects the value:

=Time(HourField+(1/24))

1 Day = 1 --> 1 Hour = 1/24

Re: Button for next value from the ListBox

marcus_sommer — Thu, 01 Dec 2016 16:36:13 GMT

You could try it with a select-action and a search-value of:

time(maketime(getfieldselections(YourTimeField) + 1))

maybe with some addtional checks like if(getselectedcount(YourTimeField), ...) or if a day-switch could be possible or some adjustments to the format and should your YourTimeField not be a real time you need to add this within the script or do some more advanced converting within this expression.

- Marcus