display data which does not meet the condition using set analysis

[Anonymous]

Hi ,

Below given is the scenario:

show only characteristic(s) that does not meet, in case

1. Current Rating - Requirement Rating < 0

2. Current Rating - Recommended Rating < 0

below given is the layout available

The slider , country and region are the filters..

the below table should meet this ( show only characteristic(s) that does not meet, in case

1. Current Rating - Requirement Rating < 0

2. Current Rating - Recommended Rating < 0  ) condition.

Kindly suggest on how to achieve this.

Attached is the sample data

Id	Type	Characteristics Name	Current Scaling	Recommended Scaling	Requirement Scaling	ProductScore
500000710	Comfort / Productivity	Dexterity	5	20	20	20.5
500000710	Comfort / Productivity	Oil grip	10	5	5	25.5
500000710	Comfort / Productivity	Dexterity	20	6	6	30.5
500000710	Comfort / Productivity	Tear	15	7	7	35.5
500000710	Comfort / Productivity	Oil grip	16	15	15	40.5
500000870	Comfort / Productivity	Sweat Factor	18	12	12	45.5
500000870	Comfort / Productivity	Tear	19	16	16	50.5
500000870	Comfort / Productivity	Oil grip	7	11	11	55.5
500000870	Comfort / Productivity	Dexterity	5	15	15	60.5
500000870	Comfort / Productivity	Dexterity	5	5	5	65.5

kindly help in how to achieve this using set analysis.

Thanks in advance.

[sunny_talwar]

But what is the requirement here? I mean based on the data you have provided... which rows do you want to show up on your chart? and is this something you want to handle in the script or front end of the application?