Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

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

Tags (3)
2 Replies
MVP
MVP

Re: How to add a row on some condition

maybe with dynamic update

Never used but here you can find some info

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

Not applicable

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.

Community Browser