Re: Can we create Straight Table using Direct Disc... - Page 2 - Qlik Community

Anonymous · ‎2016-10-26

Can we create Straight Table using Direct Discovery

sunny_talwar · ‎2016-10-26

This is a layout condition or displaying the value of col1? Also is there only one value to see? May be you need to use Concat() function here?

Concat(if(col1=OSUser(),col2))

Anonymous · ‎2016-10-27

This does not work...

When I try to fetch the values inside text box, it says, "Error: Internal fatal error".

stabben23 · ‎2016-10-27

Can you show us the script?

sunny_talwar · ‎2016-10-27

OSUser() usually gives more than just the username, it gives the domain name and then the username. Does your col1 include the exact match of OSUser()? May be you want to use a wildmatch?

Concat(if(WildMatch(OSUser(), '*\' & col1), col2))

or

Concat(if(col1 = SubField(OSUser(), '\', 2), col2))