topic Re: Group by Function to get the right values for the Metric in QlikView

Group by Function to get the right values for the Metric

Mon, 23 Sep 2013 14:20:55 GMT

I am trying to get the correct values for the Metrics which are influenced by two metrics, The Issue is I want to display the value in a straight table with one dimension, but the metric should include the granularity with both the dimensions one which is present and the hidden. Like In other BI tools (BO) it is done through functions like 'For each' and 'For All', Is there any specific function that I can use to get the desired result.

Re: Group by Function to get the right values for the Metric

jagan — Mon, 23 Sep 2013 14:43:18 GMT

Hi,

Try using the Aggr()

Ex: Sum(Aggr(Sum(Sales), Dimension1, Dimension2))

Regards,

jagan.

Re: Group by Function to get the right values for the Metric

Mon, 23 Sep 2013 14:48:43 GMT

You can add both metrics as a dimension of the straight table.

Within the presentation tab you're able to hide the dimension (Hide Column)

Re: Group by Function to get the right values for the Metric

Mon, 23 Sep 2013 15:13:37 GMT

Thanks Erik, I am already doing this workaround, but curious to know if we can do this through functions. I tried Aggr(), it also is not giving me the required result.

Re: Group by Function to get the right values for the Metric

Mon, 23 Sep 2013 15:19:32 GMT

Hi Jagan - Tried using the Aggr() Function followed By the first and second Dimensions..

=Sum(Aggr(Sum(MetricStatus), MetricName, InitiativeName)),, still this is not giving me the required result. also tried all the permutations with the same formula, still no desired result. Any other thoughts.