topic Re: Problem with conditional show in pivot in QlikView

Problem with conditional show in pivot

Tue, 21 Oct 2014 16:05:19 GMT

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

Re: Problem with conditional show in pivot

Anonymous — Tue, 21 Oct 2014 16:07:51 GMT

Try:

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

Marc.

Re: Problem with conditional show in pivot

Tue, 21 Oct 2014 16:17:44 GMT

That doesn't work

Re: Problem with conditional show in pivot

Anonymous — Tue, 21 Oct 2014 16:21:57 GMT

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.

Re: Problem with conditional show in pivot

alex_millan — Tue, 21 Oct 2014 16:30:56 GMT

Hi,

you may also try:

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

As expression:

GetFieldSelections(calendar) = 'Calendar Year'

Regards.

Re: Problem with conditional show in pivot

Tue, 21 Oct 2014 16:34:47 GMT

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

Re: Problem with conditional show in pivot

Tue, 21 Oct 2014 16:36:26 GMT

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

Re: Problem with conditional show in pivot

alex_millan — Tue, 21 Oct 2014 17:07:32 GMT

Then excuse me, I misunderstood your question.

Regards.