topic Re: restrict specific user data in QlikView https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372076#M615981 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;market={'DOMESTIC'}, party_name - ={'ALEX*'} &gt;} basicvalue)</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 05:48:31 GMT tresB 2017-08-09T05:48:31Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372074#M615979 <P>.</P> Sun, 14 Apr 2019 15:24:55 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372074#M615979 xyz1 2019-04-14T15:24:55Z Re: restrict specific user data https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372075#M615980 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(if( "market"='DOMESTIC', <STRONG>if(not <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">WildMatch(</SPAN> party_name ,'ALEX*' ),</STRONG> (basicvalue))))</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 05:46:17 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372075#M615980 prma7799 2017-08-09T05:46:17Z Re: restrict specific user data https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372076#M615981 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;market={'DOMESTIC'}, party_name - ={'ALEX*'} &gt;} basicvalue)</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 05:48:31 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372076#M615981 tresB 2017-08-09T05:48:31Z Re: restrict specific user data https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372077#M615982 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">or try<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(not <SPAN style="font-weight: inherit; font-style: inherit;">WildMatch(</SPAN> party_name ,'ALEX*' )&nbsp; and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">"market"='DOMESTIC' </SPAN>,</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">basicvalue))</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 05:49:06 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1372077#M615982 prma7799 2017-08-09T05:49:06Z