I have created a dynamic dashboard. The correct expression for each metric is determined by the data type and comes in with the data.
What I want the data to look like is this:
MetricID |
Value |
LowerTarget |
UpperTarget |
1 |
7282 |
500 |
10000 |
2 |
90179 |
5 |
100 |
3 |
32 |
1 |
50 |
4 |
16 |
100 |
300 |
5 |
17391 |
25 |
75 |
6 |
56551 |
100 |
200 |
7 |
1394762 |
50 |
2000 |
I have tried a few things, and I can get what I expect for either the maxstring or the minstring or if I select only one metric ID, but I need to get the whole list, like in the image above.
![datagrrl_0-1680534092088.png datagrrl_0-1680534092088.png](https://community.qlik.com/t5/image/serverpage/image-id/104070iA7701FEF120A5458/image-size/medium?v=v2&px=400)
I have attached a sample app and sample data.
TIA