2 Replies Latest reply: Feb 12, 2015 3:49 AM by Rohit Krishna RSS

    How to add a row on some condition

      Hi I am new to qlikview. I have a doubt. I want to know if it is possible or not in qlikview. Suppose i have a table tb1 with following data:

      username    existing role

      abc              manager

      def               storekeeper

       

      I also have a separate list of roles in another table tb2 which is as following:

      roles

      security

      accountant

      manager

      storekeeper

       

      if i select a new role e.g. accountant in tb2 then in tb1 a new row should be added and the table will be like as following

      username    existing role

      abc              manager

      abc              accountant

      def               storekeeper

        • Re: How to add a row on some condition
          Massimo Grossi

          maybe with dynamic update

          Never used but here you can find some info

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

          • Re: How to add a row on some condition

            Actually let me give you complete details which I have done in Excel but I want to implement it in Qlikview.

            If I select a user name from the list the complete details of his(like user name, existing role etc) will be dispalyed. Now I want to propose a new role through some user input. The moment user input is provided the table should add a new row in the table with the new proposed role for that user.

            e.g. if table tb1 consist

            username    existing role

            abc              manager

            def               storekeeper

            Now i select user 'abc' and i propose a new role 'accountant' to him through some user input then table tb1 should display

            username    existing role

            abc              manager

            abc              accountant

            def               storekeeper

             

            Kindly tell me me if this entire thing is possible in qlikview and how easy it is to implement this.