topic Re: Help with syntax error in QlikView

Help with syntax error

Tue, 26 Aug 2014 20:28:15 GMT

Hi,

I’m trying to match NT user with list from a data file

= if (({$<UA.NTUserName = {'$(=Upper(OSUser()))'}) , [UA.Full Name],UA.NTUserName )

Thanks in advance

Lax

Re: Help with syntax error

JonnyPoole — Tue, 26 Aug 2014 20:35:26 GMT

does this work ?

if ( UA.NTUserName = Upper(OSUser()) , [UA.Full Name], UA.NTUserName )

Re: Help with syntax error

Tue, 26 Aug 2014 20:39:30 GMT

Hi Jonathan,

Please see the correct condition

= if (({$<UA.NTUserName = {'$(=Upper(OSUser()))'}) , ,UA.NTUserName )

Thanks

Laxman

Re: Help with syntax error

Tue, 26 Aug 2014 20:53:47 GMT

No, I'm trying to match OSUSER() with data field values "NTUserName"

Re: Help with syntax error

JonnyPoole — Wed, 27 Aug 2014 12:54:05 GMT

Ok. Sorry. I reread the post but i'm unclear on the desired outcome. Can you provide any more description or screenshot of what you want to see ?

Based on what i've read , If the data field value equals the OSuser, you want to display the user name (and hide the rest) ? That would be an expression like this. The else clause evaluates to null() and those values would be hidden by default in a chart .

= if ( UA.NTUserName = Upper(OSUser() ) ,UA.NTUserName )

Re: Help with syntax error

Wed, 27 Aug 2014 13:10:10 GMT

Hi Jonathan,

Thanks for your response , please find the attached QVW file

Thanks

Laxman

Re: Help with syntax error

Wed, 27 Aug 2014 15:53:22 GMT

I did the workaround; please find the attached QVW file.

Re: Re: Help with syntax error

JonnyPoole — Wed, 27 Aug 2014 17:40:39 GMT

Here is a sample app

text box expression as follows:

= if ( isnull( only( {$<UA.NTUserName={'$(= upper(OSUser()))'}>} [UA.Full Name] ))=-1,'Different User', only( {$<UA.NTUserName={'$(= upper(OSUser()))'}>} [UA.Full Name] ))

Re: Help with syntax error

Wed, 27 Aug 2014 18:39:53 GMT

Thanks it works ,

so to match data value we need to use “ONLY” function

I’m new to QlikView

Laxman

Re: Help with syntax error

JonnyPoole — Thu, 28 Aug 2014 00:51:22 GMT

MMore specifically, to use set analysis it needs to be in the context of an aggregation function.

SInce you looking for only 1 textual value however, only() is the right aggregation function to use .