Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!

Former Member replied

Hi,

Have a push button and map the destionation of your chart ( value that changes) as the source and some other cell as the destination. Now check if the input value changes or not.

Eg:

Chart destination :A1

Push button source : A1, Destination:B1

Check if i/p value changes or not : B6==IF(A1=B1,0,1). This will return 0 if value didn't change and 1 if it changes.

Map the destination of check box into some other cell

For Eg :

C4. This will have 1 if the check box is checked else will hold 0.

Now we have logic to find out if the value is changing and check box is selected or not in two diferent cells. now write the following logic.

say A4.

A4= =IF(AND(B6=1,C4=1),1,0)

This will have 1 only if both conditions are satisfied.

Now map the trigger cell to A4. and give When value becomes 1.

Please try and reply. This should work.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question