Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_scotchford
Specialist
Specialist

Conditional Display of a Straight Table not working

Hi All

I am developing a large document (>10 sheets, 5Mil records) on my i5 Laptop in prep for our server provisioning.

Previously I have had a chart (viz Straight Table) that displays conditionally via a count of distinct of a dimension.

This has worked and works in a smaller doc as well when tested, the functionality of this now does not work, i.e. the

chart displays persistently.

I have tried reducing the data set to a few thousand rows and removed all sheets except one.

I was wondering if anyone has had similar issues with conditional display of charts/tables ?

I do not have any problems with conditional dimensions on a chart for example.

Many thanks

Paul

1 Solution

Accepted Solutions
paul_scotchford
Specialist
Specialist
Author

Ok I found the issue, clearly I have switched on a document security attribute , in this case the "Show all Sheets and Objects" was checked, this will result in the issue I have reported here

View solution in original post

5 Replies
sunny_talwar

Have you tested the expression in a text box object that it still seems to be working?

Siva_Sankar
Master II
Master II

As mentioned by sunny, test the conditional expression in text box and make sure it returns appropriate value, if not share a sample application or the condition that you are using. we may try looking into this and help you.

paul_scotchford
Specialist
Specialist
Author

Yes to all of the above, I only posted here as the issue is confounding me. I may hold off until our server is provisioned, my Laptop may be under spec'd for this doc size and bespoke functionality.

I created a new doc and can make the cond chart work using the same approach.

paul_scotchford
Specialist
Specialist
Author

Ok I found the issue, clearly I have switched on a document security attribute , in this case the "Show all Sheets and Objects" was checked, this will result in the issue I have reported here

Siva_Sankar
Master II
Master II

Paul,

Great and thanks for letting us know.