Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
hitha1512
Contributor III
Contributor III

To pick required Value based on multiple conditions

Hi Team,

Below is sample data I have and I 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, then

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

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

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.

ContractRankTier ValueDate
Premier Inc9428058/05/2019
MedAssets 9300003/24/2019
Vizient 9611508/05/2019
Cardinal Health8428058/23/2019
HealthTrust Purchasing Group8428058/05/2019

 

Result :

ContractRankTier ValueDateBest Value
Premier Inc9428058/05/2019 
MedAssets 9300003/24/2019 
Vizient 9611508/05/2019 
Cardinal Health8428058/23/2019 
HealthTrust Purchasing Group8428058/05/2019TRUE

 

Any help is appreciated!

Regards,

Hitha Dhani

16 Replies
Deepak87
Partner
Partner

Hi @sunny_talwar ,

How to do it in front end?

also the tier value are 5 digit now. but if the tier value field length is not constant means, how to do it?

 

Regards,

Deepak

sunny_talwar

You can try this using Rank() function on top of -(Rank + [Tier Value]/1e5 + Date/1e10) to determine  rank 1... Rank 1 will be your lowest value.

Also, I would need to see an example for what you mean by Tier Value. This is kind of dependent on each value for each section because I am trying to weight them a little differently. But based on possible range of values, we can determine the weights.

Deepak87
Partner
Partner

Hi @sunny_talwar 

Tier Value is an amount. can range from 0 to max a million

sunny_talwar

Sorry, but are you working on a similar issue or do you work with @hitha1512 ? I just want to make sure I understand how your issue is related to the one in question.

In that case, may be create value like this

Rank*1e10 + [Tier Value]/1e5 + Date/1e10

Multiplied Rank by 10,000,000,000 to make sure Tier Value doesn't end up exceeding Rank (hence adding more weight to Rank).

Do you get the idea? It is all about giving more weight to the field which is first in order of decision making and less weight to the field which is last in order of decision making.

Deepak87
Partner
Partner

Hi @sunny_talwar ,

Kind of  me and @hitha1512  are working on same issue.

I tried your solution and it's seems to be working.

Thanks a lot.

sunny_talwar

Okay that is great. @hitha1512 is your issue resolved as well? If it is, then please close this thread.

hitha1512
Contributor III
Contributor III
Author

@sunny_talwar  me and Deepak were working on the same issue.

thanks a ton 🙂  much appreciated 🙂