Discussion Board for collaboration on QlikView Scripting.
How can I enable or disable any expression based on specific Cyclic group level?
Thanks for helping me on this..
Go to Solution.
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
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.
Yes, you can use the getcurrentfield function to find out which field is the active one in the cyclic group:
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.
(note the square brackets around the group name)
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)
Just now tried without If and same result. It is disabled at all levels.
Thank you Marcus
Hi Marcus, Now it worked.
I used following condition :- GetCurrentField([BU Mix])='Business Unit'
Thank you so much everyone for help