Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulhv1
Creator II
Creator II

Can we have sub-totals in straight table chart

Hi,

I have create a table as under

Dept     Project                                               Amount

IT         Hardware                                            10000.00

IT         SOFTWARE                                        3000.00

CIVIL    Furniture                                            100000.00

CIVIL    BUILDING AT NEW LOCATION          5000000.00

.

.

.

.

.


I want this table with sub-totals on dept.

i.e.

Dept     Project                                               Amount

IT         Hardware                                            10000.00

IT         SOFTWARE                                        3000.00

            Total                                                  13000.00

CIVIL    Furniture                                            100000.00

CIVIL    BUILDING AT NEW LOCATION          5000000.00

             Total                                               5100000.00

             Grand Total                                     5113000.00

10 Replies
Not applicable

No you cannot.

its_anandrjs

You have to create the inline table and then in the charts use the Pick function then you achieve this. But why you not use the pivot table for this.

VishalWaghole
Specialist II
Specialist II

Hi Rahul,

I don't thing so we can accomplish this in straight table but for that you can use Pivot table.

Hope it will work.

- Regards,

Vishal Waghole

PradeepReddy
Specialist II
Specialist II

In straight table, you can get the sub-totals

Try to use the Pivot table to get the sub-totals

er_mohit
Master II
Master II

Yes

See the attached file

jagan
MVP
MVP

Hi,

There is no default setting in Straight table, but you can do this in Pivot table easily.  Anyway if you want to do this Straight table only then refer below link for solution.

Sub Total Handling

Regards,

jagan.

satyadev_j
Specialist
Specialist

Hi,

You can achieve this by doing some work around. You have to create separate column with existing project and Total/Grand Total and than link to existing column.

In expression side, you may have to use pick function to calculate total and grant total.

Make sure you are doing proper sorting order.

Thanks

PradeepReddy
Specialist II
Specialist II

Jagan,

Can you please explain the process to achieve this using Straight table.

I gone through the QVW which you have developed for the reference, but not able to see any straight table.

There is only pivot table and an Image included in Text object.

Regards,

Pradeep

jagan
MVP
MVP

Hi Pradeep,

PFA file.

Regards,

Jagan.