QlikView Scripting

[durgabhavani]

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

[sunny_talwar]

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

[durgabhavani]

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

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.

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]

Anyone!

Please look into this.