Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

How to hide detail lines when wanting to show just average in chart

How do I show just my average in the chart instead of the 2 numbers that are displaying.

Gerry.

average.JPGaverage1.JPG

1 Reply
sunny_talwar

Something like this:

=If(Dimensionality() = 0, Avg(Aggr(Sum(VALUE), DIM)))

Replace Sum(VALUE) with your current Expression and DIM with all your dimensions in the chart.

Capture.PNG