Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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)))

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: GetCurrentField

Sorted out...

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

1 Reply
MVP
MVP

Re: GetCurrentField

Sorted out...

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