topic Need Help in Aggrgation in QlikView

Need Help in Aggrgation

sunil2288 — Thu, 10 Nov 2016 09:40:52 GMT

Hi All,

I have a problem of aggregating a value on a dimension which can be used in a Pivot Table and can be looked upon other dimension. Basically i have

Owner, Brand, Country, Dim and the Expression is Sum(KPI)* Value

This Value, Type and Country are coming from a Table Called Ex Rate. Means For each of the Type out Of A,B,C,D and then for each of Country(i.e Currency like AUD, EUR ..)- I have a corresponding USD exchange rate(Known as Value).

Problem:-

After Selecting a particular Type out of A,B,C,D.

In the Pivot Chart I have Owner, Brand, Dim is there . I want to Take a summation of KPI *Value. This Value should automatically considering all Currency and Push all 'Value' and then multiply with Sum(KPI).

Currently when i include Country(Currency) field only this Chart is visible . I just want to make this Summation of KPI considering all related Currency .

Please hlep me.

Best Regards

Sunil

Re: Need Help in Aggrgation

kaushiknsolanki — Thu, 10 Nov 2016 09:43:12 GMT

Hi Sunil,

It will be better if you can post some sample example along with your selections and expected output.

Regards,

Kaushik Solanki

Re: Need Help in Aggrgation

sunil2288 — Thu, 10 Nov 2016 09:46:42 GMT

From the Above image if u can see, below Aug 2016 I expect "6334070.32", which is the sum of all the Country.

I hope u understand the requirement.

Re: Need Help in Aggrgation

kaushiknsolanki — Thu, 10 Nov 2016 09:51:28 GMT

Try this,

Sum(Aggr(Sum(KPI)*Value,Owner,Brand,Country,Dim))

Regards,

Kaushik Solanki

Re: Need Help in Aggrgation

Anonymous — Thu, 10 Nov 2016 09:54:30 GMT

Try Show Partial Sums On the Owner field and play around with the other options highlighted

Re: Need Help in Aggrgation

sunil2288 — Thu, 10 Nov 2016 09:56:45 GMT

Awesome. It's Working. Thanks So much. I din't expect i will get the Answer so soon .

Re: Need Help in Aggrgation

kaushiknsolanki — Thu, 10 Nov 2016 10:24:16 GMT

If you got your answer, kindly mark the answer post as correct.

below link will help to understand how to do that.

Qlik Community Tip: Marking Replies as Correct or Helpful

Regards,

Kaushik Solanki