Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis for avg caluclation

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

1 Solution

Accepted Solutions
MarcoWedel

dimension: date

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

View solution in original post

5 Replies
Not applicable
Author

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
Master II
Master II

Can you upload an example?

MarcoWedel

dimension: date

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

Not applicable
Author

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>

Not applicable
Author

Thanks all appreciate your help.