Current Day as a list box

[helen_pip]

Dear Qlikview user

I have several date list boxes  I.e. Year, Month and Quarter.  I would like 2 additional list boxes, where if the user clicks on the box, the data will show information for Current Day and Current Week

I have created a list box where the field expression is: =Date(Now()), however when I click on it, the data does not interact with the list box

Could someone kindly guide me as to how I can create a list box or button where the user can select the Current Day or Current week

Kind Regards

Helen

[shraddha_g]

Try using max(yourdatefield)

[Gysbert_Wassenaar · Accepted solution]

I have created a list box where the field expression is: =Date(Now()), however when I click on it, the data does not interact with the list box

Well, that's because Now() is a function and not a value from a field in your data model. That listbox is completely independent of your data model and thus won't have any effect on anything.

What you can do instead is use Text box objects (or buttons) and add Select in Field actions to those objects so that a click on the object will make a selection in your date field. You can find an example here: Re: Create a date range within a button

[helen_pip]

Hello Gysbert

Thank you for the advice, with your help I was able to achieve my desired results

An action on a text object where the action was select in Field: =('>=' & Today())

Thanks

Helen