How to use cyclic group in Action propertis of any object..

[ashishpalkar]

Hi Experts

I have created one cyclic group in my chart.

I want to use same cyclic group in my text object's action properties. Upon clicking on text button cyclic group should activate and change values accordingly.

Thanks in advance.

[Oleg_Troyansky · Accepted solution]

Hi Ashish,

I don't think you can control the Cyclic Group using Actions - at least, not without some tricky Macros that would also possibly impact the overall performance of your application.

You could reach a similar functionality if you replace your Cyclic group with a Calculated Dimension that's based on a variable and control the variable by the Actions that are linked to the Text Object's properties.

For example:

Calculated Dimension:    $(vDim)

Action:

     Set Variable vDim,

     Value: = (IF vDim='Customer', 'Product', IF(vDim = 'Product', 'Location', 'Customer'))

In this simple example, the Ddmension will cycle between Customer, Product, and Location.

cheers,

Oleg Troyansky

Learn advanced Qlik techniques in my book QlikView Your Business.

[ashishpalkar]

Thanks Oleg for quick updates,

can you send me example qvw is possible.

[Oleg_Troyansky]

Hi Ashish,

unfortunately, I barely have time to answer questions like yours, let alone create sample applications... I think I spelled out the solution quite clearly in my message. Why don't you create an example and post here for everyone else's benefit.

cheers,

Oleg Troyansky

[HirisH_V7]

Hi,

From troyansky Reply,

I have prepared an example,Here it looks like,

By using a variable in, Text object ->action->External -> Set Variable.

vDim = = IF(vDim='Customer', 'Product',   IF(vDim = 'Product', 'Quantity', 'Customer'))

Then By placing same Variable in chart, as a calculated dimension.It will get affected accordingly by clicking on text object

HTH,

PFA,

HirisH