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: 
Not applicable

Use multiple ShowSheetCondition

can we use multiple conditions on SHOWSHEETCONDITION??

Can someone gimme a syntax?

Thank you

5 Replies
its_anandrjs
Champion III
Champion III

Hi,

You can Activate Sheet, Activate Next Sheet, Activate Previous Sheet, Avtivate Object.

Rgds

Anand

Not applicable
Author

can u gimme an example how to use Activate Sheet??

Not applicable
Author

I have a dashboard with multiple sheets. We have sorted them into 4 departments. So i'm using welcome page with buttons to view these sheets now when department button is clicked.

Now I have to add conditions for columns from table which defines access for user.

user sheet1 sheet 2 sheet 3

sam  A              B             A

should show sheet only if sheet1='A'

Not applicable
Author

Have anyone come across similar scenario in section access??

erichshiino
Partner - Master
Partner - Master

Hi, KRISHNA_S

I believe this thread can help you out:

http://community.qlik.com/message/102967#102967

In your first question ( can we use multiple conditions on SHOWSHEETCONDITION??) , in the showsheetcondition I usually use a boolean logic:

= if( count( id) = 1 and only(id)=3,1,0)

or

= if ( only(id) = '50',1,0)

Hope this helps,

Erich