Discussion Board for collaboration on QlikView Scripting.
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.
You can create the Cyclic Group with out Macro ? why you need Macro ?
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.
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 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.
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.