Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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