Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

2/3 of Majority match with Rangesum

Hi Experts,

For the below chart my requirement is:

2/3 Majority is 7. 

Now I need to match the 2/3 Majority with the rangesum value which is equal or less than equal max value.

In this case, Rangesum 2+5 is equal to  2/3 Majority which is 7. 

Now I need to highlight the AudienceSensorRating "PG" Since it falls under that range. 

 

I have attached my QVF as well. 

Purushothaman_0-1677725963589.png

Anyone, Please help. @ogster1974  if possible please help. Thank you!

2 Solutions

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

The only way I got it to work was by using ranking on the 2/3 majority.  Perhaps you can leverage that approach.

ogster1974_0-1677757985951.png

 

View solution in original post

vinieme12
Champion III
Champion III

alternatively

if(count(AudienceSensorRating)>fractile(total aggr(count(AudienceSensorRating),SensorRanking),2/3) ,1 red() )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

6 Replies
Purushothaman
Partner - Creator III
Partner - Creator III
Author

@ogster1974

I have managed to do until here:

Screenshot 2023-03-02 185356.jpg

But I am unable to add another column to show only value of "PG" .

I have attached the latest working file with this.

Please help!!!

ogster1974
Partner - Master II
Partner - Master II

The only way I got it to work was by using ranking on the 2/3 majority.  Perhaps you can leverage that approach.

ogster1974_0-1677757985951.png

 

Purushothaman
Partner - Creator III
Partner - Creator III
Author

Can share me the QvF app , if possible. 

please thanks you! 

ogster1974
Partner - Master II
Partner - Master II

All I did was removed the sensor ranking column and put If(Rank(Column(1))=1, Red(),Green()) in background setting.

Column(1)=to your 2/3 Majority measure.

vinieme12
Champion III
Champion III

alternatively

if(count(AudienceSensorRating)>fractile(total aggr(count(AudienceSensorRating),SensorRanking),2/3) ,1 red() )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Purushothaman
Partner - Creator III
Partner - Creator III
Author

@vinieme12 

Thank you for your help!!! it's working. Much appreciated.