topic Re: Query on pivot table total in QlikView

Query on pivot table total

Wed, 25 Nov 2020 16:16:04 GMT

Dear,

Having a pivot table As the attached image, which includes a column of "Totals", there is the possibility of creating a UN "Text object" in sheet Y That said "Text object" represents the total of Said table In this case "26".

The idea is to be able to add in that "Text Object" number that "26" another air total of another pivot table.

Waiting A good welcome,

Say hello.

Eduardo

Re: Query on pivot table total

Frank_Hartmann — Tue, 01 Aug 2017 17:06:54 GMT

Not sure if i understood you correctly, but if you want to show the Total in a

textbox please have a look at the attached sample

Re: Query on pivot table total

Tue, 01 Aug 2017 19:23:55 GMT

Dear Frank

Thank you very much for the example, unfortunately I could only solve part of the problem.

What I want to do in is the following (The results that are in red color, is what I want to place in a "Text Object"):

Re: Query on pivot table total

Frank_Hartmann — Wed, 02 Aug 2017 05:26:53 GMT

see attached qvw

hope this helps

Re: Query on pivot table total

neha_shirsath — Wed, 02 Aug 2017 06:32:28 GMT

Why you want to put red numbers in Text object ? because if you make any selection in Pivot then size of chart will vary and this text object place will be fixed. Might be i'm not getting your question.