Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

xyz1
Contributor III

?

.

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: restrict specific user data

Try like this

sum(if( "market"='DOMESTIC', if(not WildMatch( party_name ,'ALEX*' ), (basicvalue))))

View solution in original post

3 Replies
prma7799
Honored Contributor III

Re: restrict specific user data

Try like this

sum(if( "market"='DOMESTIC', if(not WildMatch( party_name ,'ALEX*' ), (basicvalue))))

View solution in original post

MVP
MVP

Re: restrict specific user data

Try like:

sum({<market={'DOMESTIC'}, party_name - ={'ALEX*'} >} basicvalue)

prma7799
Honored Contributor III

Re: restrict specific user data

or try

sum(if(not WildMatch( party_name ,'ALEX*' )  and "market"='DOMESTIC' ,basicvalue))