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: 
renjithpl
Specialist
Specialist

Display sum/total of pivot table in a variable

Hi All,

Is there a way to show one of the column total from a pivot table in a variable or a text box.?

Regards

Ranjit

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You cannot reference the values in a chart or table; to recalculate the value, use the chart column expression in an sum(aggr(...)) expression, using the chart dimensions as the dimensions in the aggr clause.

If you provide more information, someone will be able to provide more specific assistance.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Sokkorn
Master
Master

Hi Ranjit,

Try to create variable: vTotalSale=SUM(TOTAL Sale)

Regards,

Sokkorn

renjithpl
Specialist
Specialist
Author

Thanks Jonathan, you are right, i used Sum(Aggr()), i got the result!!