How to set default value for listbox on opening the qvw

[SNR1]

HI All,

I Have below requirement

I need to select/set list box default version I s 20180523

how we can do it.

once data uploaded new filed 20180621 will added then new filed should be default value . I tried triggers used to it but nothing impressed.

PLease help us guys

Thanks iN Advance

[SNR1]

Hi SUnny

list box how to exclude values in above example

I want to exclude values 0222

0322

without match function

did u have any suggestions?

Thanks in Advance

[sunny_talwar]

May be using set analysis

=Text(Max({1<Source1 -= {"*0222", "*0322"}>}Num#(Source1), 2))

[SNR1]

Thanks SUnny

one more question in above list if I need to show only top value (20171026)

and after only (201804 to 201806) is it any other solutions we have

[sunny_talwar]

No sure I understand your question

[SNR1]

hi sunny,

list box expression is =if(not Match(Source1,'20171011','20171122)','20171221','20180123'),Source1)

list box values generated/created in script.

without excluding the values is there any other way to create the list box  as shown above in script

im concatenating the table so that 2018 year values will arrive properlly

[sunny_talwar]

You want to ignore dates from before 2018? Is that what you are looking for?

[SNR1]

ha except 20171026 and once 2018 values remains same