topic Re: Logic Help aggregation in QlikView

Logic Help aggregation

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

hi all

i have data like below

ID,Value

A,10

B,20

C,30

D,40

F,50

OutpuT required

ID,Value

A,10

B,20

C,30

D,40

F,50

E, Avg(A,B)

F, avg(C,F)

Regards

Abhay

Re: Logic Help aggregation

girirajsinh — Sat, 14 Jan 2017 09:25:45 GMT

Hi Abhay

You may achieve same in two ways.

1. Use RESIDENT load and create two extra field and use 'if' condition for calculating Average for it.

2. while showing in chart, you may create "Calculated Dimension"

Re: Logic Help aggregation

petter — Sat, 14 Jan 2017 09:29:08 GMT

E=15 and F=40

Re: Logic Help aggregation

abhaysingh — Sat, 14 Jan 2017 09:29:17 GMT

can you provide sample pls?

Re: Logic Help aggregation

petter — Sat, 14 Jan 2017 09:30:51 GMT

Can you provide more context please?

Re: Logic Help aggregation

girirajsinh — Sat, 14 Jan 2017 09:32:59 GMT

Re: Logic Help aggregation

MK_QSL — Sat, 14 Jan 2017 09:35:32 GMT

Data:

Load * Inline

[

ID,Value

A,10

B,20

C,30

D,40

E,50

];

Load 'F' as ID, Avg(Value) as Value Resident Data Where Match(ID,'A','B');

Load 'G' as ID, Avg(Value) as Value Resident Data Where Match(ID,'C','D');

//Change value of ID according to your need.

Re: Logic Help aggregation

abhaysingh — Sat, 14 Jan 2017 09:57:58 GMT

can i achieve it in front end?

Re: Logic Help aggregation

petter — Sat, 14 Jan 2017 10:10:21 GMT

Yes of course: