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.

[Anonymous]

stalwar1‌ any thoughts on the above question ??

Kindly share if you have any

Thanks in advance

[Anonymous]

swuehl‌ any thoughts on the mentioned post?? please suggest on how to achieve this.

Thanks in advance

[chinnuchinni]

what is your desired output ?

can you please elaborate little more...................and please attach the accurate sample data.

[Anonymous]

Hi Praveen ,

The desired output is in the table which will display the records which

does not meet, in case

1. Current Rating - Requirement Rating < 0

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

below is the given 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

[sunny_talwar]

Would you be able to attach your file to look at this?

[Anonymous]

Hi Sunny ,

attached is the qvw file with the sample data .

Thanks

[chinnuchinni]

try with this:

LOAD Id,

    Type,

    [Characteristics Name],

    [Current Rating],

    [Recommended  Rating],

    [Requirement Rating],

    ProductScore,

      [Current Rating] - [Recommended  Rating] as Recmnt_diff,

      [Current Rating] -  [Requirement Rating] as Req_diff

FROM

(txt, utf8, embedded labels, delimiter is '\t', msq)

where [Current Rating] - [Recommended  Rating] > 0 and [Current Rating] -  [Requirement Rating] > 0 ;

[sunny_talwar]

You want to show rows which meet these two conditions?

Requirement Rating < 0 and Recommended Rating < 0

but all the rows in the sample don't meet these two conditions? Everything is positive and well above 0, so you would want to see nothing? or is this based on the slider above where if you select 6 for example, then only this row will show?

[Anonymous]

Hi Sunny ,

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

1. Current Rating - Requirement Rating < 0

2. Current Rating - Recommended Rating < 0

i have given the sample data , that's y the values are positive or above 0 , kindly modify the values accordingly

But the requirement remains same.

Thanks