Metric Value Aggregation issue

[AsifS]

 Hi,

I have a fact column in the fact table with quarter as one of the dimension, when I just create the metric on the fact column it is not aggregating across all quarters , but it is showing some sigle row value. This is in Qlik Sense. Anyone has idea?

[sunny_talwar]

Is Admin Fee% a measure or dimension? Also, how do you get 0.02?

[AsifS]

Admin Fee% is a Metric, Its a Fact table column which gives the percentage value. Ideally 0.02 means 2% effectively.

Hope this helps !

[AsifS]

OOPS! By the way M1 metric is nothing but Admin Fee %,

[sunny_talwar]

---

@AsifS wrote:
Admin Fee% is a Metric, Its a Fact table column which gives the percentage value. Ideally 0.02 means 2% effectively.

Hope this helps !

---

But what is the logic behind getting 0.02? In other words, how do you derive 0.02 from the sample image you have shown?

[AsifS]

Well The Metric Formula is Sum(Admin Fee %) , just a summation on the column. For instance you can see that it is populating correctly in the grid for every quarter, But let say if I select 2013-Q2 and 2014-Q2 from the filter then my M1 object which is nothing but a KPI object for Admin Fee % metric should aggregate the data for the two selected quarters.(0.03+0.01) this dynmic aggregation is not happening. Not sure if this is the issue with the model.

[sunny_talwar]

But how are you evening getting this 0.03 and 0.01

From the image we see that 2013-Q2 is associated with 0.01, 0.02, 0.03, 0.04 and 2014-Q2 is associated with 0.01, 0.02, 0.03, 0.04.. so I expect to see 0.01+0.02+0.03+0.04+0.01+0.02+0.03+0.04 = 2?