Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem with conditional show in pivot

Hi,

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

7 Replies
marcarreras
Valued Contributor

Re: Problem with conditional show in pivot

Try:

if(only(getfieldselctions(calendar))='Calendar Year'), 1,0)


Marc.

Not applicable

Re: Problem with conditional show in pivot

That doesn't work

marcarreras
Valued Contributor

Re: Problem with conditional show in pivot

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..

Marc.

alex_millan
Contributor III

Re: Problem with conditional show in pivot

Hi,

you may also try:

Object properties --> Layout tab --> Show --> Conditional

     As expression:

          GetFieldSelections(calendar) = 'Calendar Year'

Regards.

Not applicable

Re: Problem with conditional show in pivot

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

Not applicable

Re: Problem with conditional show in pivot

I have used the expression before posting here but it is working in sample application but it is working weird in my main application

alex_millan
Contributor III

Re: Problem with conditional show in pivot

Then excuse me, I misunderstood your question.

Regards.

Community Browser