topic Use multiple ShowSheetCondition in QlikView

Use multiple ShowSheetCondition

Wed, 19 Oct 2011 19:19:48 GMT

can we use multiple conditions on SHOWSHEETCONDITION??

Can someone gimme a syntax?

Thank you

Use multiple ShowSheetCondition

its_anandrjs — Wed, 19 Oct 2011 19:24:12 GMT

Hi,

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

Rgds

Anand

Use multiple ShowSheetCondition

Wed, 19 Oct 2011 19:27:28 GMT

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

Use multiple ShowSheetCondition

Wed, 19 Oct 2011 19:47:08 GMT

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'

Use multiple ShowSheetCondition

Wed, 26 Oct 2011 14:45:01 GMT

Have anyone come across similar scenario in section access??

Use multiple ShowSheetCondition

erichshiino — Thu, 27 Oct 2011 15:24:04 GMT

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)

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

Hope this helps,

Erich