topic Re: Dynamic Date selection using a button in App Development

Dynamic Date selection using a button

Anonymous — Wed, 03 Jan 2018 19:53:56 GMT

My requirement is to create buttons to select Current month, Previous month and Previous Quarter from Reporting_Date Field

Suppose Current Reporting date is 11/30/2017, then Clicking on previous month gives 10/31/2017.

Use cases:

multiple options (current/previous month end or previous quarter-end) can be selected at the same time

I have attached a sample app for reference

Re: Dynamic Date selection using a button

sunny_talwar — Wed, 03 Jan 2018 20:05:20 GMT

Configured the first two buttons, see if they work for you

Re: Dynamic Date selection using a button

sunny_talwar — Wed, 03 Jan 2018 20:11:30 GMT

Configured the Previous Quarter-end also

Re: Dynamic Date selection using a button

Anonymous — Wed, 03 Jan 2018 20:36:29 GMT

Thank you:)

Re: Dynamic Date selection using a button

sunny_talwar — Wed, 03 Jan 2018 20:40:49 GMT

If my response help you get what you wanted, I would suggest you to appropriately mark the correct and helpful responses rather than marking assumed answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Dynamic Date selection using a button

Anonymous — Thu, 04 Jan 2018 19:25:18 GMT

Hi Sunny,

Thanks, Although not part of my requirement, but just to play around with logic, I added 12/31/2017 and 01/31/2018 in Inline load for reporting date and suddenly it doesnt work.

Re: Dynamic Date selection using a button

sunny_talwar — Thu, 04 Jan 2018 19:28:36 GMT

Has to do with the formatting... check now... and please mark the correct and helpful responses (instead of marking Assumed Answer)