Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Try:

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


Marc.

Not applicable
Author

That doesn't work

Anonymous
Not applicable
Author

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
Creator III
Creator III

Hi,

you may also try:

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

     As expression:

          GetFieldSelections(calendar) = 'Calendar Year'

Regards.

Not applicable
Author

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
Author

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
Creator III
Creator III

Then excuse me, I misunderstood your question.

Regards.