topic Re: Current Day as a list box in QlikView

Current Day as a list box

helen_pip — Wed, 16 Nov 2016 15:33:29 GMT

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

Re: Current Day as a list box

shraddha_g — Wed, 16 Nov 2016 15:36:46 GMT

Try using max(yourdatefield)

Re: Current Day as a list box

Gysbert_Wassenaar — Wed, 16 Nov 2016 17:14:42 GMT

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

Re: Current Day as a list box

helen_pip — Thu, 17 Nov 2016 08:36:32 GMT

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