topic Re: Current date button in QlikView

Current date button

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

i have a set of sales data, from the year 2000 to current date. I would like to have a butto/shortcut which by default displays the current year sales.

Regards.

Re: Current date button

Anonymous — Wed, 01 Jun 2016 13:12:34 GMT

Try this

=Sum({<Year={'=Max(Year)'}>}Sales)

Re: Current date button

sunny_talwar — Wed, 01 Jun 2016 13:18:17 GMT

I think you missed the dollar sign

=Sum({<Year={$(=Max(Year))}>}Sales)

Re: Current date button

santiago_respane — Wed, 01 Jun 2016 13:19:45 GMT

You can achieve that by:

adding a button
add a trigger that selects the desired value in the desired field
your expressions can be like:
- for max year (may or may not current year)
  - =MAX(YEAR)
- for current year (may or may not have values to display)
  - =YEAR(TODAY(1))

Please let me know if this helps.

Kind regards,