Skip to main content

MicrosoftTeams-image (30)

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


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) ;


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


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:)


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)


Reply