topic Re: Help me in below scenario? in QlikView

Help me in below scenario?

durgabhavani — Thu, 23 Jul 2015 02:22:58 GMT

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

Re: Help me in below scenario?

sunny_talwar — Thu, 23 Jul 2015 02:27:47 GMT

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

Re: Help me in below scenario?

durgabhavani — Thu, 23 Jul 2015 02:38:38 GMT

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

Re: Help me in below scenario?

durgabhavani — Thu, 23 Jul 2015 04:04:34 GMT

Anyone!

Please look into this.