topic Re: List box selection in QlikView

List box selection

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

Hi ,

I have used the date field as Sold date(m/d/yyyy)

I need my list box to be select by default dynamically last 3 days.

Ex: for today my list box should select 3/13/2017,3/12/2017 and 3/11/2017 if num of day increases it will rollback.

Thanks..

adamdavi3s — Tue, 14 Mar 2017 12:26:51 GMT

How do you want this to be triggered? On document open?

If so I would use a field trigger and just toggle select today(), today()-1 etc

Please see attached example (settings> document properties > triggers> on open)

nareshthavidishetty — Tue, 14 Mar 2017 12:39:02 GMT

Thanks..

If i need to show the dates from month start to today()-1 how to get this.

Thanks..

adamdavi3s — Tue, 14 Mar 2017 12:40:06 GMT

Ok so what is your actual requirement as it seems different from your original post?

If I opened the dashboard today, you would expect it to select from 1st March to 13th March?

adamdavi3s — Tue, 14 Mar 2017 12:43:50 GMT

If this is what you expect, please see the attached, just use one 'select in field' with

='>='&MonthStart(Today()) & '<=' & Date(Today()-1)

nareshthavidishetty — Tue, 14 Mar 2017 12:44:49 GMT

Yes exactly..But i need selections at sheet level and it won't disturb other sheets.

Thanks..