Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total of a expression in dynamic table

I have a table with a dynamic expression of the sum ... I wonder if I can show that the total sum in the last row below. Thank you.

1 Solution

Accepted Solutions
v_iyyappan
Specialist
Specialist

Hi,

I am straight table with expression Sum(Amount) And Presentation tab Select OrderNo and 'Totals'  Click the

Totals on last row.

I attached sample file. Please see that.

Regards,

Iyyappan.

View solution in original post

4 Replies
Not applicable
Author

Hi,

You can show sum in charts, i.e. pivot or straight tables. In the chart properties, go to Presentation, choose the dimension you want to show as totals, activate "Show Partial Sums" and click "Subtotals at Bottom".

Regards,

sebablum

v_iyyappan
Specialist
Specialist

Hi,

I am straight table with expression Sum(Amount) And Presentation tab Select OrderNo and 'Totals'  Click the

Totals on last row.

I attached sample file. Please see that.

Regards,

Iyyappan.

Not applicable
Author

Ok, but i need this in dynamic table... its possible?

v_iyyappan
Specialist
Specialist

Hi,

     Dynamic table means what using macro concept?.Otherwise can u please attach sample file.

Regards,

Iyyappan