Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Tobievr
Contributor
Contributor

Count unique, Based on lines large than an Average Formula in Gauge

Hi

I am very new to QlikSense. I have a table and in this I have a Start and End Date and this works out an Average for everything. What I need to do, is count the transactions that are larger than the Average.

Current Dimension Formula:

=avg(if(NetWorkDays(WAYBILLDATE,PODDATE)>'','',NetWorkDays(WAYBILLDATE,Today())))

Average Could be 3, so all transactions that is greater than 3 based on above formula, must be displayed in a KPI Chart. 

I am note sure if the above is sufficient information, but would appreciate feedback or assistance with this.

Thank you

Labels (2)
1 Reply
Yoshidaqlik
Creator II
Creator II

Hi,

I'll put an example that maybe you can adapt to what you need

In this case, the days that have a transaction count greater than the average expression you entered are counted.

 

sum(
  aggr(
    if(
      count(transaction)
      >
      avg(total
          if(
            NetWorkDays(WAYBILLDATE,PODDATE)>'','',NetWorkDays(WAYBILLDATE,Today())
          )
      ),
      1
    )
  ,dimension_date)
)

 

 

Regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng