Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can we create Straight Table using Direct Discovery

Can we create Straight Table using Direct Discovery

13 Replies
sunny_talwar

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
Not applicable
Author

This does not work...

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

stabben23
Partner - Master
Partner - Master

Can you show us the script?

sunny_talwar

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))