Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

GetCurrentField

I have cyclic group named Selection with below dimensions...

CustomerName

Item

Brand

Want to use this cyclic group in bar chart for with there is a reference line showing average sales.

What is wrong in below? It's simply not working !

Avg(Aggr(SUM(InvoiceValue),GetCurrentField(Selection)))

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP
Author

Sorted out...

Avg(Aggr(SUM(InvoiceValue),$(=GetCurrentField(Selection))))

View solution in original post

1 Reply
MK_QSL
MVP
MVP
Author

Sorted out...

Avg(Aggr(SUM(InvoiceValue),$(=GetCurrentField(Selection))))