topic Re: Problem in pivot table vs CG in QlikView

Problem in pivot table vs CG

Wed, 09 Apr 2014 14:28:25 GMT

I think, This is a bug.

I have used the 4 cyclic group in pivot table.

Cg:

1. Part (PartNo, PartDesc)

2. Customer (CustomerName,CustomerID)

3. actualCalendar(Year week month)

4. fiscal calendar (Year week month)

Expression Sum(Amount)

and I make last 2 cg data (actual calendar, fiscal calendar) as a column (drag and drop as a column) and I gave enable condition for that two cg respectively Isactualcalendar=1 for actualCalendar and Isfiscalcalendar=1 for FiscalCalendar(this variable is changing while clicking button , so that any one calendar cg shows at a time).

And now my issue is I am not able to change the dimension for fiscal calendar in that report(I got popup 'dimension list' and if click on it then nothing happen.) , I can change the Actualcalendar dimension.

it is working fine when we have a all cg as a column(with out drag and drop).

Please help me on this.

Regards,

Kabilan K.

Re: Problem in pivot table vs CG

Wed, 09 Apr 2014 14:40:54 GMT

can you post a qvw file

Re: Re: Problem in pivot table vs CG

Wed, 09 Apr 2014 15:37:24 GMT

PFA.

Re: Re: Re: Problem in pivot table vs CG

Thu, 10 Apr 2014 05:31:42 GMT

I am able to select the dimensions in both CG3(A_Year,A_Week) and CG4(F_Year,F_Week) as per the visibility.

This is what i did:

Clicked on "SwitchActualCalender" button

-> Chart showing CG1,CG2,CG3

-> In CG3, i am able to select either of the dimensions avaiable in CG3

Clicked on "SwitchFiscalCalender" button

-> Chart showing CG1,CG2,CG4

-> In CG4, i am able to select either of the dimensions avaiable in CG4

Hope,I am clear !

Re: Problem in pivot table vs CG

Thu, 10 Apr 2014 07:54:51 GMT

Pivot table how is it looks?

Can u share the screen shot?

after changing the dimension see whether table the correct dimension or not?

Regards,

Kabilan K.

Re: Problem in pivot table vs CG

Thu, 10 Apr 2014 07:55:30 GMT

Which version are u using?

Re: Re: Problem in pivot table vs CG

Thu, 10 Apr 2014 08:39:46 GMT

I am using 11 SR2

PFA the screenshots

Re: Problem in pivot table vs CG

Thu, 10 Apr 2014 09:52:36 GMT

We are using SR1. So they are recover this problem in SR2