Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

A strange behavior when we hide/show a sheet conditionally

I cannot replicate this issue with a sample dashboard, but it is happening in our actual dashboards.

Let me just describe the strange behavior in text.

For example, There are 3 sheets.

The 'Main' and 'Always Show' sheets always appear.

The 'Conditional Show' sheet show only when =ONLY(Dim1)='A'.

2017-09-14_094427.png

However when I select 'C', the 'Conditional Show' still appear.

2017-09-14_094815.png

Then I switch to other sheets (eg: Always Show), the sheet is hidden at this moment.

2017-09-14_094941.png

Then I go back 'Main' and choose back 'A', but the 'Conditional Show' sheet is still hidden.

2017-09-14_095217.png

The sheet appears again only when I switch to another sheet.

2017-09-14_095345.png

It seems that the hide/show condition recalculate when I switch between the sheets, but not when I select a value of a dimension.

The user experience is not good. Any hints about this strange behavior?


1 Solution

Accepted Solutions

Re: A strange behavior when we hide/show a sheet conditionally

Do you have alternate state in your dashboard?

6 Replies
BarbCline
New Contributor III

Re: A strange behavior when we hide/show a sheet conditionally

Have you tried =GetFieldSelections(Dim1) = 'A' ?  Perhaps that will work better.

Re: A strange behavior when we hide/show a sheet conditionally

Do you have alternate state in your dashboard?

BarbCline
New Contributor III

Re: A strange behavior when we hide/show a sheet conditionally

No, I do not have an alternate state.  Do you think that's what's causing your issue?

Re: A strange behavior when we hide/show a sheet conditionally

My issue? I am not the one who created this thread Barb

BarbCline
New Contributor III

Re: A strange behavior when we hide/show a sheet conditionally

Ha ha, oops!    My apologies ... I must stop multi-tasking

Not applicable

Re: A strange behavior when we hide/show a sheet conditionally

You got the point.

I overlook the alternate state

Community Browser