Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

percentage calculation

Dear all,

I'm coping a big problem, for me of course, but I'm not able to go on

I have the following tables:

Details

Year     Month     Area    GLaccount     Value   

2012     01            xy         1              150000

2012     01            xy          2               50000

2012     02            xy          3              150000

2012     02            aa          1               50000           

2012     02            aa          2               40000  

...

Purchase

Year     Month     Area          Total Purchase

2012          01     xy              250000

2012          02     xy              100000

2012          02     aa              100000

I need to produce the following pivot for 2012

               GlAccount   Value           

AREA     TOTALpurchase               1         %                2           %                 3            %

xy               350000                  150000    42,85           50000     14,30          150000     42,85      

aa               90000                      50000   55,55            40000     44,45       

                                                      

The percentage values, are calculated as  GLaccount_Value_for area/Total purchase for area

I don't know how to solve it.

Help please

Thanks in advance

Community Browser