topic Re: How to fix the pivot table area size in QlikView

How to fix the pivot table area size

bhuprakash — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am stuck at one place as i have added Total text box in bottom of the pivot table.

When I filter the data then pivot area change according the selection but I want it not to change.

Below is the screenshot to understand it better. Please help me to resolve it.

I want area size as given in second image.

Anil_Babu_Samineni — Sat, 16 Dec 2017 13:04:04 GMT

May be Add {1} with your expression, And what i understand is you need to UN Check this?

bhuprakash — Sat, 16 Dec 2017 13:10:07 GMT

Hi Anil,

I tick marked on size to data in pivot and no option is enable in text box.

bhuprakash — Sat, 16 Dec 2017 13:14:29 GMT

Thanks Anil, Now i have unticked in pivot table and it working as expected.

Anil_Babu_Samineni — Sat, 16 Dec 2017 13:47:18 GMT

Please Mark "Correct answer" for respect answer instead of yours. That may useful and helps to others

bhuprakash — Sat, 16 Dec 2017 13:55:45 GMT

I have done the same. Thanks

Anil_Babu_Samineni — Sat, 16 Dec 2017 13:58:23 GMT

If you see, You mark yourself. If you didn't feel sounds my response is not a way you are looking. That's fine..

Cheers

bhuprakash — Sat, 16 Dec 2017 17:03:14 GMT

hahaha...Anil, you given the resolution as I wanted.

Mistakenly I marked my reply as correct Answer... Will take care of this.