topic set analysis in QlikView

set analysis

Fri, 16 Dec 2011 13:50:29 GMT

Where can i put a set analyses in this formula so that selections are ignored. I tried everything but it don't seems to work Formula:stdev(aggr(sum(XXX),y,y)) Wherever i put a set analysis selection the result still changes when making a selection. Peter

set analysis

brenner_martina — Fri, 16 Dec 2011 13:55:48 GMT

Hi, Peter,

I think the following is right:

stdev({<Field1=,Field2=,... >} aggr(sum(({<Field1=,Field2=,... >} XXX),y,y))

Field1= means, a selection in this field will not effect the sum and stdev

Greetings from Munich

Martina

EVACO GmbH

set analysis

jagan — Fri, 16 Dec 2011 14:21:22 GMT

Hi,

Try using {1} in you expression.

stdev(aggr({1}sum({1}XXX),y,y))

{1} - disregards the selections

Regards,

Jagan.

set analysis

Fri, 16 Dec 2011 14:23:16 GMT

You should try :

stdev( {1} aggr( {1} sum(XXX),y,y))

Then your expression will be independant from all selections in your application.