set analysis for avg caluclation

[#1]

iam using dimension date in chart and want to caluclate averge number of treatments for each counter

how can we write expression in set analysis

[#2]

Hi,

Can you outline your Data in terms of Column/ rows as an example ?

That may help understand and provide you a soulution !

Cheers !

[ecolomer]

Can you upload an example?

[MarcoWedel · Accepted solution]

dimension: date

expression: Avg(Aggr(count(treatments),counter))

[#5]

Hi Marco,

Thanks for your expression.

I will try and let you know.

@Enrique @ Priyanka appreciate your quickly response.

will provide sample data if expression did not work.

Regards,

Ram.

On Sun, Jan 11, 2015 at 12:42 AM, Marco Wedel <qcwebmaster@qlikview.com>

[#6]

Thanks all appreciate your help.