Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi All

I have a Table 1.

The dimension field =

=company_ar

I dont want it to display CASH SALES  :-

I use below expression :-

=if( [company_ar]|=[CASH SALES],[company_ar])

it does not work. Can some one advise me ?

Paul

1 Solution

Accepted Solutions
brunobertels
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi

Try this expression

=if( [company_ar]<>'CASH SALES',[company_ar])

6 Replies
paulyeo11
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Mt QVF

brunobertels
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi

Try this expression

=if( [company_ar]<>'CASH SALES',[company_ar])

paulyeo11
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Thank you sir

paulyeo11
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi All

=if( [company_ar]<>'CASH SALES',[company_ar])


Above expression working fine , Now i like add one more condition 'EXPORT SALES'


I try below expression it does not work.


=if( [company_ar]<>'CASH SALES' or 'EXPORT SALES',[company_ar])

=if( [company_ar]<>'CASH SALES' and 'EXPORT SALES',[company_ar])


Can some one help me,

Paul Yeo


brunobertels
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi

Try this

=if( [company_ar]<>'CASH SALES' or [company_ar]<> 'EXPORT SALES',[company_ar])

if( [company_ar]<>'CASH SALES' and  [company_ar]<>'EXPORT SALES',[company_ar])

paulyeo11
Valued Contributor II

Re: Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

Hi Bruno


it work fine , thank you.


if( [company_ar]<>'CASH SALE' and  [company_ar]<>'EXPORT SALES',[company_ar])


Paul

Community Browser