edit expression

[#1]

hi , is there any way to give "IF" condition in Qlikview edit expression.

[its_anandrjs]

Check this mix of the if nested statements

Load Customers,Sales,

if( Sales = 15000,'Equals 15000',

if( Sales = 20000,'Equals 20000',

if( Sales > 15000,'Greater That 15000',

if( Match(Sales,10000),'Equals to 10000' )))) as SalesFlag;

Load  * inline

[

Customers,Sales

A,15474

B,10000

C,20000

D,45000

E,15000

];

[#3]

my scenario is STATUS APPR, WAPPR, WPMAPPR, close, cancel, return IN Edit expression  we want onLy three status whose status LIKE APPR, WAPPR,WPMAPPR WE DNT WANT all status.

[anbu1984]

If(Match(STATUS,'APPR', 'WAPPR','WPMAPPR'),'Status matching')

[its_anandrjs]

I Believe you load SAP table right then

Load

*

From Location

Where Match(STATUS,'APPR','WAPPR','WPMAPPR');// for loading three values

if you want to load a filed then

Load

If( Match(STATUS,'APPR','WAPPR','WPMAPPR'),'Other Status') as [Status Details]

From Location