Skip to main content
Question

Hello together,is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

  • June 9, 2022
  • 1 reply
  • 30 views
.
Level 1
Hello together, is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

      1 reply

      G
      Level 12

      Hmmmm... I think you can't, as data picker (or search box with date variables) they filter at Analysis level.

       

      You can block filtering for one OLAP table, and use the datepicker with the other.

       

      Otherwise, you will need 2 dropdown selectors or similar, assign two variables (from and to) and use them to filter one of the OLAP tables. In fact, you will create your own date picker.

       

      HTH

      Community Code of ConductAccessibility statement