Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ariel_klien
Specialist
Specialist

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
Specialist
Specialist
Author

Any Idea?

Not applicable

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

ariel_klien
Specialist
Specialist
Author

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

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
Specialist
Specialist
Author

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

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.