topic Macro to create Cycle Group in QlikView

Macro to create Cycle Group

ariel_klien — Thu, 21 Nov 2013 16:24:20 GMT

Hello all Experts.

I need to create a cycle group after hierarchy load,

The Group will contain all the levels that where created,

Does anyone have a Macro for that?

up for a Chart that contain the level for each customer.

Ariel

Re: Macro to create Cycle Group

ariel_klien — Tue, 26 Nov 2013 11:29:12 GMT

Any Idea?

Re: Macro to create Cycle Group

Tue, 26 Nov 2013 13:48:54 GMT

You can create the Cyclic Group with out Macro ? why you need Macro ?

Re: Re: Macro to create Cycle Group

ariel_klien — Tue, 26 Nov 2013 14:15:00 GMT

Hi dathu,

Thanks for your replay,

We need the macro cause the hierarchy can change in each load.

And filed are added or erased after the load.

That's way we need to create the cycle group after the reload.

Any idea?

Ariel

Re: Macro to create Cycle Group

Wed, 27 Nov 2013 03:14:20 GMT

Hi, We can customize your cyclic groups by Add Expression Button.

Please create the variables in the script to fit your Cyclic group requirements and use this variables in cyclic group creation. Each reload these variable values replace with your new field names.

Please post some more info about your scenario so community will help more.

Thanks.

Re: Re: Macro to create Cycle Group

ariel_klien — Wed, 27 Nov 2013 09:38:06 GMT

Hi dathu

Thanks for your replay.

That what I did but in some cases there is no field and it cause null values in variable and that cause null values in the cycle group.

I don't want to show null values in the cycle group. only the existing fields.

Ariel

Re: Macro to create Cycle Group

Wed, 27 Nov 2013 13:43:33 GMT

Then validate the variable weather it is null or not if null then ignore in the cyclic group.

Please post your scenario then community will help more.