topic Re: Want to Show Sub Total in QlikView Report in QlikView

Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 07:22:05 GMT

Hello Experts,

I just want to show subtotal in my QlikView report ie.

That is my Orignal Data:

Year	Month	Quarter	Name	Sales
2001	January	Q1	Tata	1000
2001	February	Q1	Tata	1000
2001	March	Q1	Tata	2000
2001	April	Q2	Tata	2000
2001	May	Q2	Tata	1000
2001	June	Q2	Tata	1000
2001	July	Q3	Tata	1000
2001	August	Q3	Tata	1000
2001	September	Q3	Tata	2000
2001	October	Q4	Tata	2000
2001	November	Q4	Tata	2000
2001	December	Q4	Tata	4000
2001	January	Q1	Barclay	100000
2001	February	Q1	Barclay	50000
2001	March	Q1	Barclay	50000
2001	April	Q2	Barclay	200000
2001	May	Q2	Barclay	100000
2001	June	Q2	Barclay	100000
2001	July	Q3	Barclay	50000
2001	August	Q3	Barclay	50000
2001	September	Q3	Barclay	100000
2001	October	Q4	Barclay	50000
2001	November	Q4	Barclay	100000
2001	December	Q4	Barclay	50000
2001	January	Q1	Reliance	25000
2001	February	Q1	Reliance	10000
2001	March	Q1	Reliance	15000
2001	April	Q2	Reliance	50000
2001	May	Q2	Reliance	50000
2001	June	Q2	Reliance	50000
2001	July	Q3	Reliance	50000
2001	August	Q3	Reliance	50000
2001	September	Q3	Reliance	50000
2001	October	Q4	Reliance	50000
2001	November	Q4	Reliance	50000
2001	December	Q4	Reliance	50000
2002	January	Q1	Tata	15000
2002	February	Q1	Tata	15000
2002	March	Q1	Tata	15000
2002	April	Q2	Tata	25000
2002	May	Q2	Tata	25000
2002	June	Q2	Tata	25000
2002	July	Q3	Tata	20000
2002	August	Q3	Tata	20000
2002	September	Q3	Tata	30000
2002	October	Q4	Tata	40000
2002	November	Q4	Tata	15000
2002	December	Q4	Tata	15000
2002	January	Q1	Barclay	400000
2002	February	Q1	Barclay	100000
2002	March	Q1	Barclay	100000
2002	April	Q2	Barclay	150000
2002	May	Q2	Barclay	70000
2002	June	Q2	Barclay	80000
2002	July	Q3	Barclay	100000
2002	August	Q3	Barclay	25000
2002	September	Q3	Barclay	25000
2002	October	Q4	Barclay	50000
2002	November	Q4	Barclay	50000
2002	December	Q4	Barclay	50000
2002	January	Q1	Reliance	3000
2002	February	Q1	Reliance	3000
2002	March	Q1	Reliance	4000
2002	April	Q2	Reliance	20000
2002	May	Q2	Reliance	10000
2002	June	Q2	Reliance	10000
2002	July	Q3	Reliance	10000
2002	August	Q3	Reliance	10000
2002	September	Q3	Reliance	5000
2002	October	Q4	Reliance	5000
2002	November	Q4	Reliance	10000
2002	December	Q4	Reliance	10000

I wat to show my record in group Like -

Name- Tata

coloumn1 column2 column3

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

Subtotal-

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

Name - Barclay

coloumn1 column2 column3

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

Subtotal-

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

Name- Reliance

coloumn1 column2 column3

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

Subtotal-

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

Grand Total-

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

How can i do this one,Please help me.

Right now i have created one table object where i have taked columns and then i am coping my object i report but i am unable to generate Group subtotal.

Thanks in Advance.

Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 07:30:00 GMT

Hi,

Sub total option available in pivot table in

Presentation -> Subtotals -> select Top/Bottom

Regards

Anand

Re: Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 07:41:56 GMT

Hi,

See the attached sample file it will explain what you requires with subtotal at year level if you want it on Name, Month, Quarter level you can do that.

Regards,

Anand

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 08:48:35 GMT

Thanks for Reply Anandrjs,

but still i am not getting that option.

I have only one option in Properties -->Presentation -->Total--> Total On First Row/ Total on Last Row

But i want sub total on group basis.

I cant open that QVW file.

What i created is :

Go to new Sheet Object -->Chart -->Allowoing Type-->Pivot Table .

then i am selecting my dimentions.

but in Presentation tab i am not getting that option.

If i am wrong please correct me.

Thanks.

Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 08:55:12 GMT

Hi,

You need to change the type of chart from straight table to pivot table the option you say it is for Properties -->Presentation -->Total--> Total On First Row/ Total on Last Row straight table only. By right click on properties and change the type of chart from general tab there is a many option then go to apply.

After that go to presentation tab there you see options Subtotal on top/ Subtotal on bottom.

Regards

Anand

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 09:22:59 GMT

Hi Anand,

Still i am not getting Option.I have already choose Pivot table option in General but presentaion tab is showing

same option please find the attachment and see images,

General Tab:

Presentaion Tab:

please check where i am wrong.

Thanks.

Re: Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 09:34:19 GMT

Hi,

See the snapshots of the Pivot table selected on upfront to the straight table is pivot table and in second image subtotals display.

And let me know if you got any problem

Regards

Anand

Want to Show Sub Total in QlikView Report

SunilChauhan — Wed, 07 Sep 2011 09:48:46 GMT

hello gaurav you need to check on radio button "Subtotal on top"

go to presentation-> select below fields in left pane one by one

Year

Month

Quarter

Name

and select check show partial sum and subtotal on top

hope thiss helps You

Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 09:57:44 GMT

Hi Gaurav,

You got information from snapshots, if show let me know about that.

Regards,

Anand

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 10:09:28 GMT

Hi Anand,

Thankyou very much foo response.

I got your snapshots and it's working, but not completely .How can we show Name only once's in a group like:

Name- Tata

coloumn1 column2 column3

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

Subtotal-

And also how can i add Label like 'SubTotal-'.

Re: Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 10:28:52 GMT

Hi,

Thanks, When you go to Presentation tab there you see Dimension and Expression, there when you select Year below the optons you see the Label for Totals tex box type Subtotal there

See the snapshots.

Regards

Anand

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 10:30:00 GMT

Hi Sunil,

Thankyou very much for your reply.

It is also woring but not showing right sum.May be i am wrong with concept.

Can you tell me 'Show partial Sum' will wahat tell ti us.

Is it like if i will check this option for Name that means it will show partially sum grouping by name.

If i am wrong please correct me.

Thanks.

Seeking for your reply.

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 10:51:48 GMT

Hi Anand,

You are right it is working for changing name of the label.

but i am a bit confused. because i am checked 'Show Partial Sum' option for my four dimentions and now it is showing one-one subtotal for each row. Instead of this i want this Subtotal grouped by name or other dimetions.

I thing i am worng with some things.

I want Sum on Quaterly Basis and i checked that option for all.

Please see image and if my logic and expectation is diffrent please tell me.

Thanks you very much for your meaningful reply.

Re: Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 11:33:27 GMT

Hi Gaurav,

If you want to select the name level Subtotal value then you need to select -> Show Partial Sum -> And give the label its easy on which level you want you just need to select.

See my attached sample there is two chart one show all by Name, Quarter, Year and second one is only for Name.

Regards,

Anand

Re: Want to Show Sub Total in QlikView Report

Wed, 07 Sep 2011 13:12:25 GMT

Hi Anand,

Actually i can't access qvw file because i have demo version of QlikView.

but i am trying to make right grouping.

Tell me another thing how can i put name on group header.

Like i want to print name only once in group header.

ie.

Name- Barclay

column1 column2 column3

data data data

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

SubTotal-

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

Name-Tata

data data data

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

SubTotal-

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

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

Grand Total-

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

Please help me if you know and if posible, please sent me sanpshots.

Thanks,

Gaurav Saxena

Re: Want to Show Sub Total in QlikView Report

its_anandrjs — Wed, 07 Sep 2011 13:41:40 GMT

Hi,

In pivot you are able to show data some thing like this i below snapshot.

Regards,

Anand