Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
datagrrl
Creator III
Creator III

Use expression from field to calculate value

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

I have attached a sample app and sample data. 

TIA

Labels (1)
0 Replies