topic Merging two Pivot Table in QlikView

Merging two Pivot Table

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

Hi All,

I have and layout requirement like below:

I am trying to create two different Pivot table and merge those. But I am not able to do it properly.

Is there any other way to do the same?

I am attaching my sample App.

Please help.

Thanks,

Sarif

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:12:37 GMT

Is there any reason why you are not using a container to accommodate both of them?

Edit:

And what is merging, merging the data or just keeping two charts side by side.

Re: Merging two Pivot Table

mhmmd_srf — Wed, 14 Jun 2017 10:15:04 GMT

Can container provide the same look and feel?

Thanks,

Sarif

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:18:02 GMT

you will have something like this. Check attached app.

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:18:59 GMT

You may also play with different properties to change the layout and may be making it more attractive..

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:21:13 GMT

Hide the title bar and it looks much closer to your view.

Re: Merging two Pivot Table

mhmmd_srf — Wed, 14 Jun 2017 10:28:15 GMT

okk..this is very close to my requirement.

I need two help from you:

1. How to hide the Period Level?

2. Is there any way to fix the width of each and every cell?

Please help.

Thanks,

Sarif

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:33:11 GMT

Is Period a dimension which you dragged over? If yes you can just change the label to make it blank and reduce the width of column manually.

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 10:35:20 GMT

See this, The Chart at Top is similar to what you have and the below one I have changed it the way you want.

Attaching the QV doc for the reference.

Re: Merging two Pivot Table

mhmmd_srf — Wed, 14 Jun 2017 10:58:16 GMT

Hi Kamal,

The problem is for your case both chart is having two dimension, for me one chart is having One dimension and another is having two dimension.

So the entire layout is not allinged.

Is there any way to fix the width of each cell.

Please help.

Thanks,

Sarif

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 11:06:58 GMT

How about increasing the width of chart above to make in sync with the below chart?

like this.

Re: Merging two Pivot Table

mhmmd_srf — Wed, 14 Jun 2017 11:28:28 GMT

Not Helping Sir,

Left Hand Side is aligned, but right hand side is not .

Re: Merging two Pivot Table

kamal_sanguri — Wed, 14 Jun 2017 11:40:16 GMT

Yeah, I understand there are limitations but still if you want you can manually align them.

Goto View->Design Grid

this will create a grid and you can use those lines as baselines to align your columns (may be this will help you to align columns a bit precisely)

Re: Merging two Pivot Table

mhmmd_srf — Thu, 15 Jun 2017 10:50:26 GMT

Thanks a lot Kamal for all your help.... you helped me a lot..

Thanks,

Sarif

Re: Merging two Pivot Table

kamal_sanguri — Thu, 15 Jun 2017 11:02:16 GMT

No Worries, People here are to help each other.