topic One Pivot Table with two Dimension Conditions. Urgent in QlikView

One Pivot Table with two Dimension Conditions. Urgent

renuka_sasikumar — Thu, 27 Nov 2014 09:42:15 GMT

I have 2 dimension list and one pivot table.

Dimension 1 Dimension 2

All Division

Business Analysis Sales Group

Manpower Sales Office

Leadership Gap

So by default my pivot table will be shown on Dimension 1 all.

And even I want to show when selected Division its should show Division wise.

That means one Pivot Table with two Dimension Conditions.

Is it Possible?

Thanks & Regards,

Renuka

Re: One Pivot Table with two Dimension Conditions. Urgent

Thu, 27 Nov 2014 09:44:52 GMT

Not sure I understand your end requirement, can you post up an example of each? Sounds like it should be doable with conditional dimensions though yes.

Dimension 1 for instance sounds like it's actually 4 dimensions? Is this a group?

Re: One Pivot Table with two Dimension Conditions. Urgent

sujeetsingh — Thu, 27 Nov 2014 09:47:24 GMT

Yes it is possible

You can make the Dimension conditionally enabled.

So let a Button is set to make variable vDim =1.

Now you can set at second dimension condition as

=if(vDim=1,1,0)

Try the logic

Re: One Pivot Table with two Dimension Conditions. Urgent

renuka_sasikumar — Thu, 27 Nov 2014 09:53:34 GMT

For Dimension 1

All is nothing but three chart of Business Analysis, Manpower, & Leadership Gap.

So wen i select Business A it will show only Business same for the rest.

But I want to add one more condition with this that Wen any one selected from Dimension 2 den its should change accordingly.