topic Re: Max date selection issue in Multi box in QlikView

Max date selection issue in Multi box

dsharmaqv — Thu, 09 Aug 2018 12:17:27 GMT

Hi All

I have a requirement to select the Max date by default when user opens the qvw document.

To achive this I have enable the trigger option and select the max date. Its working fine but when user click on clear all option, every thing got deselected including date.

How to make date as consistant even after users clicks on clear all option?

Many thanks in Advance!

Deepak Sharma

Re: Max date selection issue in Multi box

sibin_jacob — Thu, 09 Aug 2018 12:27:39 GMT

Write the same trigger on Document properties -> OnAnySelect

Re: Max date selection issue in Multi box

rubenmarin — Thu, 09 Aug 2018 12:33:08 GMT

Hi Deepak, there is another action to lock the field, this way it won't be cleared but users should unluck to change the selected value.

Another option is creating a 'Clear all' button that locks the date field, clears all and unlocks the date field, but the global action to clear all still will deselect this field.

And another option is setting the date field to have always one value selected, so it can't be deselected.

A last option can go playing with triggers on change on date field, but can be difficult to manage using this way.

Re: Max date selection issue in Multi box

dsharmaqv — Thu, 09 Aug 2018 12:36:42 GMT

Thanks for your reply Sibin.

On doing this, now on opening the document...max date is not getting selected.

Re: Max date selection issue in Multi box

sibin_jacob — Thu, 09 Aug 2018 12:38:55 GMT

You can write the same trigger on Document properties ONOPEN also

Re: Max date selection issue in Multi box

dsharmaqv — Thu, 09 Aug 2018 12:57:30 GMT

No Luck

Re: Max date selection issue in Multi box

sibin_jacob — Thu, 09 Aug 2018 13:20:45 GMT

Create a listbox for date column.

Then select one value from this list box -. then go to properties -> check always one selected value

Then click on ok

after that Delete that listbox.

now if you click on clear all, always one value will be slected for Date Column.

Re: Max date selection issue in Multi box

dsharmaqv — Thu, 09 Aug 2018 13:28:03 GMT

Again No luck Sibin

Will you be able to share the sample app pls.

Re: Max date selection issue in Multi box

sibin_jacob — Thu, 09 Aug 2018 13:32:50 GMT

Is it clearing the date field now? after creating the listbox with always one selected value.

I can't upload the file due to security restriction.

Re: Max date selection issue in Multi box

dsharmaqv — Fri, 10 Aug 2018 05:09:34 GMT

Hi Sibin

always one selected value option is available in multi box as well. even I tried with list box as per your suggestion.

But n luck....Once I enable "always one selected value" Max datae trigger doesnt work and showes last saved date value.

Re: Max date selection issue in Multi box

sibin_jacob — Fri, 10 Aug 2018 05:27:50 GMT

always one selected value option is not available in multi box

Try this one

Go to Document Properties-> Trigger tab->

Add-> Select In field->

Give field column like below

=if(GetSelectedCount(Date_Column)=0,'Date_Column')

Search String

=Max(Date_Column)

Click on Okay.

Try to click on Clear ALL

Re: Max date selection issue in Multi box

tresB — Fri, 10 Aug 2018 05:53:53 GMT

PFA

1. OnOpen trigger : =Date(Max({1} Date))

2. OnAnySelect trigger : = Date(Max(Date))