Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe with dynamic update
Never used but here you can find some info
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.