Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
durgabhavani
Contributor

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

Re: Help me in below scenario?

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

durgabhavani
Contributor

Re: Help me in below scenario?

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
Contributor

Re: Help me in below scenario?

Anyone!

Please look into this.

Community Browser