Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Average Function

Hi, I am new with Qlik Sense. I am trying to use the average function and is not working. Here is what I want to do:

I have a table with KPI information in one column and the data per month in the other columns, example:

KPIJan-2016Feb-2016Mar-2016
1. Number of Claims245
2. % of past due Claims vs. Open Claims10%8%12%

So, technically, the KPI 1 should be 3.66 and the KPI 2 should be 10%. Is there anyway to do it in the same Gauge?