Skip to main content
Question

Can I operate each KPI components with date pickers which have different SAP table columns. Explained in the image below. thanks.

  • April 12, 2023
  • 5 replies
  • 47 views
Z
Level 8

MicrosoftTeams-image (30)

    5 replies

    G
    Level 12

    AFAIK a data picker creates a overall filter, that will impact all the components in the analysis.

     

    Only way I can think will be to create you date picker with dropdowns , and then apply the specific filters via variables

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • April 13, 2023

    AFAIK a data picker creates a overall filter, that will impact all the components in the analysis.

     

    Only way I can think will be to create you date picker with dropdowns , and then apply the specific filters via variables

    Thanks for your reply Guillermo. Eventhough I chose the datepicker from the dropdown, it will affect the whole analysis again as I write a date to the one datepicker. I dont want that. What I want is as follows: * When I write 01-01-2023 and 13-04-2023 to Datepicker 1 , only KPI 2 will be affected. KPI 1,3 will freeze.

    Can I do like sth in below?

    For KPI2 Component Filter;

    FILTER Affected date= MAX(AUFK.ERDAT),MIN(AUFK.ERDAT) ;

    G
    Level 12

    Thanks for your reply Guillermo. Eventhough I chose the datepicker from the dropdown, it will affect the whole analysis again as I write a date to the one datepicker. I dont want that. What I want is as follows: * When I write 01-01-2023 and 13-04-2023 to Datepicker 1 , only KPI 2 will be affected. KPI 1,3 will freeze.

    Can I do like sth in below?

    For KPI2 Component Filter;

    FILTER Affected date= MAX(AUFK.ERDAT),MIN(AUFK.ERDAT) ;

    My bad, I meant to create a "datepicker" using the component Button Dropdown, and putting the selection in a variable, the using the variable in a Component filter (or inside a CASE WHEN or a PU fucntion)

     

    Something like:

    image 

    HTH

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • April 13, 2023

    Thanks for your reply Guillermo. Eventhough I chose the datepicker from the dropdown, it will affect the whole analysis again as I write a date to the one datepicker. I dont want that. What I want is as follows: * When I write 01-01-2023 and 13-04-2023 to Datepicker 1 , only KPI 2 will be affected. KPI 1,3 will freeze.

    Can I do like sth in below?

    For KPI2 Component Filter;

    FILTER Affected date= MAX(AUFK.ERDAT),MIN(AUFK.ERDAT) ;

    hmm, let me think I will equate a variable and the date . will try it. thanks:)

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • April 13, 2023

    Thanks for your reply Guillermo. Eventhough I chose the datepicker from the dropdown, it will affect the whole analysis again as I write a date to the one datepicker. I dont want that. What I want is as follows: * When I write 01-01-2023 and 13-04-2023 to Datepicker 1 , only KPI 2 will be affected. KPI 1,3 will freeze.

    Can I do like sth in below?

    For KPI2 Component Filter;

    FILTER Affected date= MAX(AUFK.ERDAT),MIN(AUFK.ERDAT) ;

    Unfortunately, I couldnt do it.

    Do you know is there a İgnoring function. I looked the PQL library but didnt see.

    For instance, For KPI 2,3 I will write a filter in order to ignore Date picker 1,

    FILTER IGNORE (AUFK.ERDAT)

    Community Code of ConductAccessibility statement