topic Dynamic Cyclic Groups and Conditionally hiding a column in QlikView

Dynamic Cyclic Groups and Conditionally hiding a column

mee-qlik — Fri, 15 May 2015 16:04:00 GMT

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?

Re: Dynamic Cyclic Groups and Conditionally hiding a column

sunny_talwar — Fri, 15 May 2015 16:10:47 GMT

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

Re: Dynamic Cyclic Groups and Conditionally hiding a column

mee-qlik — Fri, 15 May 2015 16:44:56 GMT

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

sunny_talwar — Fri, 15 May 2015 16:55:15 GMT

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

Have a look. (PFA)

Best,

Sunny

Re: Dynamic Cyclic Groups and Conditionally hiding a column

mee-qlik — Mon, 18 May 2015 06:47:33 GMT

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