Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
just copy and paste sheet object as reference.....the changes in one will automatically reflect on other