Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ariel_klien
Valued Contributor

Macro to create Cycle Group

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

6 Replies
ariel_klien
Valued Contributor

Re: Macro to create Cycle Group

Any Idea?

Not applicable

Re: Macro to create Cycle Group

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

ariel_klien
Valued Contributor

Re: Re: Macro to create Cycle Group

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

Not applicable

Re: Macro to create Cycle Group

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.

ariel_klien
Valued Contributor

Re: Re: Macro to create Cycle Group

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.


BR


Ariel





Not applicable

Re: Macro to create Cycle Group

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.

Community Browser