topic Re: display data which does not meet the condition using set analysis in QlikView

display data which does not meet the condition using set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: display data which does not meet the condition using set analysis

Anonymous — Tue, 03 Apr 2018 06:07:34 GMT

stalwar1‌ any thoughts on the above question ??

Kindly share if you have any

Thanks in advance

Re: display data which does not meet the condition using set analysis

Anonymous — Tue, 03 Apr 2018 06:09:47 GMT

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

Thanks in advance

Re: display data which does not meet the condition using set analysis

chinnuchinni — Tue, 03 Apr 2018 06:52:47 GMT

what is your desired output ?

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

Re: display data which does not meet the condition using set analysis

Anonymous — Tue, 03 Apr 2018 07:23:42 GMT

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

Re: display data which does not meet the condition using set analysis

sunny_talwar — Tue, 03 Apr 2018 09:08:46 GMT

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

Re: display data which does not meet the condition using set analysis

Anonymous — Tue, 03 Apr 2018 10:10:50 GMT

Hi Sunny ,

attached is the qvw file with the sample data .

Thanks

Re: display data which does not meet the condition using set analysis

chinnuchinni — Tue, 03 Apr 2018 10:47:00 GMT

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 ;

Re: display data which does not meet the condition using set analysis

sunny_talwar — Tue, 03 Apr 2018 11:19:22 GMT

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?

Re: display data which does not meet the condition using set analysis

Anonymous — Tue, 03 Apr 2018 11:28:14 GMT

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

Re: display data which does not meet the condition using set analysis

sunny_talwar — Tue, 03 Apr 2018 11:31:02 GMT

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?