topic Re: Array search and compare in QlikView

Array search and compare

Fri, 12 Apr 2013 09:04:48 GMT

Hello,

first sorry for my bad english, hope you understand me.

i have a table:

target:

Only the user with "OK" see the result.

If the Login Username equal Username in the table and Hlist value = OK, then show the result

Formel:

if ( Username = OSUSER()) and Hlist1 = 'OK', sum (XX))

what ist wrong?

thanks

MayilVahanan — Fri, 12 Apr 2013 13:42:25 GMT

Try like this

if ( Username = OSUSER() and Hlist1 = 'OK', sum (XX),'')

Mon, 15 Apr 2013 08:38:45 GMT

hello

thanks, but did not work

not work:

= if ( table.UserName = OSUSER(), sum (XXX),'')

work fine:

= if ( 'domain\username1' = OSUSER(), sum (XXX),'')

what is wrong?