topic Re: How to add a row on some condition in Qlik Learning Discussions

How to add a row on some condition

Wed, 11 Feb 2015 18:55:36 GMT

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

maxgro — Wed, 11 Feb 2015 20:23:46 GMT

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

Thu, 12 Feb 2015 08:49:41 GMT

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.