topic Conditional function in QlikView

Conditional function

tizianacaem — Thu, 16 Sep 2010 11:36:31 GMT

Hello everyone.
I have a problem with the conditional functions of sheets.

I have the following list in a xlsx file

User, Sheet

user1 SH01

user2 SH02

I want to show only certain sheet (es SH01 but not SH02) for a user (es user1).

In each sheet I used the expression: fieldindex ('SHEET', SH01) but it does not work.

Suggestions?

Thanks Tiziana

Conditional function

Thu, 16 Sep 2010 11:52:10 GMT

<body>Hi, To do this you need to create an excel sheet like follows (assign '1' for the sheets the user wants to see and '0' for the sheets user doesn't want to see and then in sheet properties use conditional show =sum(distinct (SHEET1)=1) <col span="3" width="64"></col> <tr> <td width="64" height="20">USERID</td> <td width="64">SHEET1</td> <td width="64">SHEET2</td> </tr> <tr> <td height="20">USER1</td> <td align="right">1</td> <td align="right">0</td> </tr> <tr> <td height="20"> USER2 </td> <td align="right"> 0</td> <td align="right">1</td> </tr> </body>

Conditional function

Thu, 16 Sep 2010 11:57:03 GMT

The table should be like this.. and make sure to select 'Initial Data Reduction based on Section Access' "(Document Properties> Opening)

Regards,

Nilupa