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.

janardhan
Contributor

sum

Hi Friends ,

I have an issue with sum

Eg.,

ID        Date                Type     Hours

11    01/03/2012           Normal       8

         04/05/2012          Normal      10

12    01/06/2012           Norm        12

         01/07/2012          Normal      22

13    01/02/2012           Normal     24

         02/05/2012           Normal     44

-------------------------------------------------------

total                                            120

--------------------------------------------------------

My requirement is above like that

but i am getting that

ID        Date                Type     Hours

11    01/03/2012           Normal       20

        04/05/2012          Normal     

12    01/06/2012           Norm        34

        01/07/2012          Normal     

13    01/02/2012           Normal     68

        02/05/2012           Normal   

I need to display all the respected values

Thanks

3 Replies
er_mohit
Honored Contributor II

Re: sum

in your above question is  id and date are your dimension or not?

janardhan
Contributor

Re: sum

dimensions only

er_mohit
Honored Contributor II

Re: sum

ok.

in presentation tab of your pivot table you just click on partial sum of field name date corresponding and in expression write sum of that field

then it will comes like you want

hope this will helps you.

Community Browser