topic Re: Conditional enabling of expression in QlikView

Conditional enabling of expression

Fri, 21 Mar 2014 10:53:39 GMT

Hi All,

How can I enable or disable any expression based on specific Cyclic group level?

Thanks for helping me on this..

Kind Regards,

Varun

Re: Conditional enabling of expression

jsingh71 — Fri, 21 Mar 2014 11:01:19 GMT

Go to chart Properties and then Expression tab.

Select the expression which you want to enable or disable based on the condition and then checck the conditional check box and then mention condition.

Re: Conditional enabling of expression

Gysbert_Wassenaar — Fri, 21 Mar 2014 11:05:05 GMT

Yes, you can use the getcurrentfield function to find out which field is the active one in the cyclic group:

if(getcurrentfield(MyGroup)='Product',1,0)

Re: Conditional enabling of expression

Fri, 21 Mar 2014 11:12:19 GMT

Thanks Wassenaar,

Is there a way to find out MyGroup name? My cyclic group is a dimension named as 'BU Mix' but it not working with that.

=if(getcurrentfield(Bu Mix)='Product',1,0)

Kind Regards,

Varun

Re: Conditional enabling of expression

marcus_malinow — Fri, 21 Mar 2014 11:16:39 GMT

Hi Varun,

try

getcurrentfield([Bu Mix])='Product'

(note the square brackets around the group name)

Re: Conditional enabling of expression

Fri, 21 Mar 2014 11:22:52 GMT

I think we are close :

Single quotes seem to be working for identifying MyGroup but now facing another problem,

I have tried using two options and both the options are disabling expression at all cyclic levels

=if(GetCurrentField('Bu Mix')='Business Unit',1,0)

=if(GetCurrentField('Bu Mix')=[Business Unit],1,0)

Kind Regards,

Varun

Re: Conditional enabling of expression

marcus_malinow — Fri, 21 Mar 2014 11:25:51 GMT

Hi Varun,

you don't need the If condition, just

GetCurrentField([Bu Mix]='Business Unit'

This will return a Boolean, which is what the conditional show requires

Re: Conditional enabling of expression

Fri, 21 Mar 2014 11:27:58 GMT

Just now tried without If and same result. It is disabled at all levels.

Thank you Marcus

Re: Conditional enabling of expression

Fri, 21 Mar 2014 11:31:44 GMT

Hi Marcus, Now it worked.

I used following condition :- GetCurrentField([BU Mix])='Business Unit'

Thank you so much everyone for help