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.

Not applicable

Pivot Table :

  Hi,

   I am new to qlikview and using pivot table first time .

   How can I get the SUM of  Outstanding cash , If I collapse to FinMGR  or DirSFS or SrDirSFS  in pivot table . 

      My dimensions of Pivot table are  :

      SrDirSFS

      DirSFS

      FinMGR

      FC

     StudentID

  Expression  :  Outstanding Cash

  

  Example:

SrDirSFSDirSFSFinMGRFCStudentIDOutstanding Cash
Neilly , DonnaNeilly,TeamHarrington, BoydEvangelo,Tanya10111100   $   100
10222211   $    200
10333322   $      125
Paradis   Jason123456   $     200
1117777   $     300
Jones , JeffreyKristine0000001    $700
11111223    $ 250
77788899     $ 50

   

    From Above table   I want    to show

1)    SUM  by   FC     :

         Evangelo,Tanya     =  100 + 200 + 125  =    $  425  

         Paradis , Jason    =   200 +  300           =     $  500 

         Kristine                 =   700 + 250 + 50   =     $ 1000 

  2)   SUM by   FinMGR :

      

          Harrington , Boyd   =   100 + 200 + 125 + 200 + 300   =   $  925

          Jones,Jefferey       =  700  + 250 + 50                        =   $  1000

   3)  SUM  by  DirSFS :

          Neilly , team  =   100 + 200 + 125 + 200 + 300 + 700 + 250 + 50   =  $ 1925

    Follow the attached  qlikview  document to understand my question .

   

   Is there a way to see the Totals in Pivot table as per above example ?

Thanks.

1 Solution

Accepted Solutions
Not applicable

Pivot Table :

sum(Outstanding Cash)

Chart Properties, Style, Check Indent Mode check box.

3 Replies
Not applicable

Pivot Table :

sum(Outstanding Cash)

Chart Properties, Style, Check Indent Mode check box.

Not applicable

Pivot Table :

  It works. 

  

Thank you so much.

Not applicable

Re: Pivot Table :

Perfect,  It works.

  Thank you so much... 

Community Browser