Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two totals at the top of the PivotTable.

I need to create a dynamic table chart that has two totals at the top, an automatic calculated with expression and other calculated differently.
You can do this in QlikView?


on example.

The green line is the total value of the sale of the line (cream, gel, body, etc.). But the Blue TOTAL is the value of sales on the sales TOTAL.


Screenshot_2_Totais.jpg

2 Replies
rupamjyotidas
Specialist
Specialist

You can play with Dimensionality() for this requirement

Not applicable
Author

It did not work, this function makes change the TOTAL account, what I need is that the Pivot Table has 2 total.