topic Cycle Group Issue in QlikView

Cycle Group Issue

NavinReddy — Mon, 15 Jul 2013 04:50:01 GMT

Hi Community

I have one cycle group like Line of business(LOB)

if i select LOB in cycle group two fields should be added in stright table(SubLob1,SubLob2)

could some one help me

Plz Find The Attachment

Thanks,

Niranjan

NavinReddy — Mon, 15 Jul 2013 05:15:19 GMT

Guys any idea

Urgent.........

Mon, 15 Jul 2013 06:19:08 GMT

Hi Niranjan,

IF(GetCurrentField

(cyclic group name)='Line of Business',1,0)

use this expression in to condition ,

GetCurrentField(cyclic group name) will return the selected dimention in the cyclic group.

Thanks & Regards

Khemraj

Mon, 15 Jul 2013 07:09:30 GMT

Hi,

Add the calculated dimension like below.

=if(GetCurrentField(cgChart)='Line of Business',SubLob1)

=if(GetCurrentField(cgChart)='Line of Business',SubLob2)

Regards,

Kabilan K.