Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mee-qlik
New Contributor

Dynamic Cyclic Groups and Conditionally hiding a column

I have defined  3 dimension in the cyclic group $(v_dimension1),$(v_dimension2),$(v_dimension3). Then I can dynamically change the dimensions in the cyclic group setting the 3 variables. But, if one of this dimension is empty, I'd like to hide this dimension.

I try to use the expression getcurrentfield(MyGroupName)='$(v_dimension1)' or something like this.But it don't work.

I try to use getcurrentfield(MyGroupName) in a text field, it show   =$(v_dimension1) when the first dimension is select.

Any idea?

1 Solution

Accepted Solutions

Re: Dynamic Cyclic Groups and Conditionally hiding a column

I created 4 cycle groups and conditional show/hide them based on your variable value.

Have a look. (PFA)

Best,

Sunny

4 Replies

Re: Dynamic Cyclic Groups and Conditionally hiding a column

Dimension would be empty when the variable is empty, correct???

Why don't set the dimension condition like this:

Len(Trim($(v_dimension1))) > 0

I am sure I have misunderstood your question, so please forgive me if I have and please re-explain.

Best,

Sunny

mee-qlik
New Contributor

Re: Dynamic Cyclic Groups and Conditionally hiding a column

I’d like that if i choose in v_Dimension3 = N/A , in the Cyclic dimension the N/A dimension is complety hide ( see attached file)

Best

Enrico

Da: sunindia

Inviato: venerdì 15 maggio 2015 18:11

A: Enrico Bandini

Oggetto: Re: - Dynamic Cyclic Groups and Conditionally hiding a column

Re: Dynamic Cyclic Groups and Conditionally hiding a column

I created 4 cycle groups and conditional show/hide them based on your variable value.

Have a look. (PFA)

Best,

Sunny

mee-qlik
New Contributor

Re: Dynamic Cyclic Groups and Conditionally hiding a column

Thanks!

Good solution, the problem is that if the cyclic dimension are more, the cycle groups and conditional show/hide grows up !

Thanks a lot

Enrico

Community Browser