Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help

Hi Dear Friends;

I faced with problem when I was studying in qlikview. I created a pivot table and wrote my formulas. Then I created a new pivot table. In this new table, I needed to get total only numbers of previous pivot table. Instead of copying all of expressions, I would like to make referance in new table.

Thanks in advance,

Best Regards.

3 Replies
jvitantonio
Specialist III
Specialist III

That's the automatic total made by Qlik. You can crete a variable with the total sum SUM(Total Value) and then use it in your new table like

=$(MyVariable)/somethingElse

Not applicable
Author

Hi qlikuser14;

Firstly; I would like to thank your kindly help. Alas, I couldn't understand what you meant. Could you please more detailed.

Thanks again,

Best regards

Not applicable
Author

just copy and paste sheet object as reference.....the changes in one will automatically reflect on other