Discussion Board for collaboration on QlikView Scripting.
There is a problem when I have applied a conditional show in pivot table
My condition is as follows '(getfieldselctions(calendar)='Calendar Year')'
It should display data when my current selection is only calendar year. But the issue is when my current selection is Fiscal year all the dimensions that are present is also gets disabled.
Is this because of the above condition or this behaviour is because of the qlikview association
if(only(getfieldselctions(calendar))='Calendar Year'), 1,0)
That doesn't work
I forgot the equal signal:
=if(only(getfieldselctions(calendar))='Calendar Year'), 1,0)
However, if it doesn't work yet, please explain further your requirement in order to look for an appropiate solution..
you may also try:
Object properties --> Layout tab --> Show --> Conditional
GetFieldSelections(calendar) = 'Calendar Year'
Layout condition will not be applicable because I have different dimensions so, it does applies to all the dimensions so it doesn't work out
I have used the expression before posting here but it is working in sample application but it is working weird in my main application
Then excuse me, I misunderstood your question.