Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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