Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

AsifS
New Contributor

Metric Value Aggregation issue

 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?

Image 3.PNG

6 Replies

Re: Metric Value Aggregation issue

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

AsifS
New Contributor

Re: Metric Value Aggregation issue

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
New Contributor

Re: Metric Value Aggregation issue

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

Re: Metric Value Aggregation issue


@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
New Contributor

Re: Metric Value Aggregation issue

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.

Re: Metric Value Aggregation issue

But how are you evening getting this 0.03 and 0.01

image.png

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?