I have an app where i want to change the data value based on the user input from the dashboard. Say i have the following table below. How would i go about setting up a dashboard to where they can filter on the ID and Attribute to change the Value and I cant utilize a QVD (company reasons) or vizlib writeback functionality. My initial thought is a variable input and partial reload but any guidance is appreciated.
ID
Attribute
Value
1
Color
Red
1
Age
21
2
Color
Green
2
Age
48
3
Color
Purple
3
Age
36
If i select ID =1, Attribute = Color, Value change to Green then i want the table to read
You could maybe use the function getfieldselections() which will input your selection - and depends on the volume you could use some if statements to counter what is visible in the values