Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help me in below scenario?

Hi All,

If the Audit status is 'Assign to' and then we want to use Audit Info as 'ROLE:Analyst'  in audit table, then it needs to map (To map with the Activ_Role we need to remove suffix ROLE in audit table.) with the 'Activ_Role' Analyst' and show the field as Active_Role_Final.

Please find the sample qvw file and advice me the code to implement.

Thanks,

Durga

3 Replies
sunny_talwar

Not sure I understand your requirement. Can you may be re-explain?

durgabhavani
Creator III
Creator III
Author

First we need to click on assign to in audit table,

11.JPG

Next If we click on audit info ROLE:Analyst, then it need to map with Activ_Role 'Analyst'. For mapping the Audit Info field to Activ_Role, we need to remove suffix ROLE: in Audit Info field then we need to map to Activ_Role.

12.JPG

Finally i need to show the Active_Role_Final as one new field with values like Analyst,Architect,Consultant....

Hope this helps.

Please Advice.

Thanks,

Durga

durgabhavani
Creator III
Creator III
Author

Anyone!

Please look into this.