6 Replies Latest reply: Sep 19, 2014 7:54 AM by Agis Kalogiannis RSS

    contidional hiding of sheets

      hi everyone ,

       

      i have a qlikview document with two tabs , i wish to hide one of the tabs for a particular user ,

      i have tried doing this by using the section access option in the insert menu when we edit script ,

      and then loading a table with the user ids and vaiables which i have used in the condional opening option in sheet properties.

      still i am not able to hide the sheets .

      please guide me through this .

      Section 

      Access;

      LOAD

      * INLINE

      [
      ACCESS, USERID, PASSWORD
      admin, a, 123
      user, b, 456
      ]

      ;

      Section

      Application

      ;

      LOAD

      * INLINE

      [
      USERID,f1, f2
      a,1, 1
      b,0, 1
      ]

      ;

      in the condional opening option of sheets i am typing the condition if (sum (f1)=1)