Need to find the Best value based on Multiple condition

[Deepak87]

Hi All,

Below is sample data i have and need to calculate the best value based on few condition as below.

1. Check the Minimum rank, if there are more than one row\records

2. check the minimum Tier value, if there are more than one row\records

3. check the minimum date and consider that as Best Value

Column 5, 6, 7 are calculated value (min of rank Tier value & Date)

But Best value should be based on above condition and precedence only, First it has to check the rank, then tier value and then date.

How to achieve this in Qliksense table chart.

[Deepak87 · Accepted solution]

There was a solution provided by @sunny_talwar on this issue in a different post.

https://community.qlik.com/t5/Qlik-Sense-App-Development/To-pick-required-Value-based-on-multiple-co...

Thanks a lot @sunny_talwar