Skip to Content

Refresh on Trigger when Trigger cell:(value changes = TRUE and SHow trend = 1) value becomes TRUE

Hi All,

I am using Label selection and Tree map to represent high level data in SAP Dashboards, and there are detail trending charts but don't want to display and run until show trending is checked and a block is selected from Tree map

A cell value is derived from Label and Tree map block selections

Show Trending value is from Check box selection

Cell value changed and Check box(show trending) is selected, then query needs to fired.

Refresh on Trigger when Trigger cell:(value changes = TRUE and Show trend = 1) value becomes TRUE

How can i achieve this functionality in SAP Dashboards 4.1, can you please direct me if there are other alternatives?

Thank you very much!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 04, 2015 at 05:14 AM

    Hi,

    Use a connection refresh button to trigger the query and set dynamic visibility to it. It should be visible only when the check box is selected "AND" value is changed. write logic for that. So even if the value in destination cell from chart changes, the query will not be triggered since it is not visible. AND has to be set. It Worked. This may help you.

    Add comment
    10|10000 characters needed characters exceeded