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?
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.