Exclude specified values from data set

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

Hi All,

I have a data set of values for which I need to calculate avg and stdev.

The data set is changing according to selection

the problem is how to exclude specific values from this data set based only on the value itself for example :

SpecHighNum	SpecLowNum	ResultNum
34.57	29.57	31.0597
34.57	29.57	2.194e-005
34.57	29.57	1.709e-005
34.57	29.57	8.61e-005
34.57	29.57	31.07532
34.57	29.57	31.07119
34.57	29.57	30.4953
34.57	29.57	30.49381
34.57	29.57	30.49354
34.57	29.57	30.49419
34.57	29.57	30.49384
34.57	29.57	31.05629
34.57	29.57	-2.374e-005
34.57	29.57	-1.366e-005
34.57	29.57	3.512e-005
34.57	29.57	31.04768
34.57	29.57	31.03064
34.57	29.57	30.9684
34.57	29.57	31.02707
34.57	29.57	31.01977
34.57	29.57	31.07196
34.57	29.57	31.06855

in this case I need to ignore values of ResultNum that are +/-5*stdev +/- ResultNum

Is that possible?

Thanks in advance

Re: Exclude specified values from data set

Brett_Bleess — Wed, 04 Dec 2019 19:17:26 GMT

Viki, you would need to load your entire model, calculate the standard deviation, then do resident load to drop the values that do not fit within the range you want, believe you would need to use the Peek function to check the next record, compare and keep or drop etc.

Best I can do other than that is give you the Design Blog area of Community to search the posts there to see if you can find something that fits what you need.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Actually, I may have found something that I think will put you on the right track to a degree:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

Regards,
Brett

topic Exclude specified values from data set in QlikView

Exclude specified values from data set

Re: Exclude specified values from data set