topic How to put dynamic listbox change in selection? in QlikView

How to put dynamic listbox change in selection?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have week filed like 2016/10,2016/11,2016/12,2016/13,2016/14,2016/15 here i need to select always last week default.

here 2016/14 should be default selected and if week changes to 2016/16,then week should be selected 2016/15 dynamically could you please tell me .

Thanks,

Rajesh

Re: How to put dynamic listbox change in selection?

Chanty4u — Mon, 11 Apr 2016 10:47:54 GMT

Create date island. with min date and max( date)-7 .you just create calendar date for weeks

>= max(datefield) - 7

Re: How to put dynamic listbox change in selection?

sunny_talwar — Mon, 11 Apr 2016 10:54:05 GMT

I guess you can add a on open trigger I guess with a search String like this:

Max(YearWeekField) -> You might need to format this like YYYY/WW to get this working

MaxString(YearWeekField)

Re: How to put dynamic listbox change in selection?

Anonymous — Mon, 11 Apr 2016 10:56:10 GMT

But this main purpose is to run batch file and export data through macro,means trigger won't be works????

Re: How to put dynamic listbox change in selection?

sunny_talwar — Mon, 11 Apr 2016 10:59:12 GMT

I am not familiar with your situation, but trigger is when you will open the application. Is the macro exporting the chart without opening the application?

Re: How to put dynamic listbox change in selection?

Anonymous — Mon, 11 Apr 2016 11:04:27 GMT

Yes..that time we are not moving on sheet activate trigger,if we are doing manually yours is best solution

Re: How to put dynamic listbox change in selection?

sunny_talwar — Mon, 11 Apr 2016 11:10:40 GMT

Also if this is not a table box we are exporting, may be you can add a set analysis statement to your expression for straight table or pivot table?

Re: How to put dynamic listbox change in selection?

settu_periasamy — Mon, 11 Apr 2016 11:21:59 GMT

How do you want to select value? If you want to select when open the document you can try Open Document trigger..

=WeekName(Max(Week)-1)

This will change, if the Date / Week data added .

may be check the sample..