topic Re: edit expression in QlikView

edit expression

Tue, 17 Jun 2014 07:45:10 GMT

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

Re: edit expression

tresB — Tue, 17 Jun 2014 07:47:27 GMT

if( Amount>= 0, 'OK', 'Alarm' )

Re: edit expression

MK_QSL — Tue, 17 Jun 2014 07:49:40 GMT

Can you elaborate little more please?

Re: edit expression

ashfaq_haseeb — Tue, 17 Jun 2014 07:51:25 GMT

something like this

if(A=1 or B=1,1,0)

Regards

ASHFAQ

Re: edit expression

its_anandrjs — Tue, 17 Jun 2014 07:51:31 GMT

See example

Load Customers,Sales,

if( Sales >= 15000, 'Above 15000', 'Less Than 15000' ) as SalesFlag

Load * inline

[

Customers,Sales

A,15474

B,10000

C,20000

D,45000

E,15000

];

----------------------------------------------------

Or in the load script other ways you can use it

if a=1 then

load * from abc.csv;

sql select e, f, g from tab1;

end if

if a=1 then; drop table xyz; end if;

if x>0 then

load * from pos.csv;

elseif x<0 then

load * from neg.csv;

else

load * from zero.txt;

end if

Re: edit expression

Tue, 17 Jun 2014 09:02:38 GMT

ok but if have three or more condition in that columns what should we do in that case ?? if( Amount>= 0, 'OK', 'Alarm' )

Re: edit expression

anbu1984 — Tue, 17 Jun 2014 09:04:49 GMT

Like this

if( Amount= 0 Or Amount= 100 Or Amount= 200, 'OK', 'Alarm' )

Re: edit expression

ashfaq_haseeb — Tue, 17 Jun 2014 09:06:21 GMT

Then go with nested if.

Regards

ASHFAQ

Re: edit expression

tresB — Tue, 17 Jun 2014 09:08:54 GMT

I guess, nested if is what you mean. The syntax is like:

=If( Amount>=0, 'Positive' , If( Amount< -100, 'Less than minus 100' , 'In Between zero and -100'))

Other way with Pick() & Match() is like:

=Pick(Match(Amount, 1,2,3,4), 'One', 'two', 'Three', 'Four')

Re: edit expression

its_anandrjs — Tue, 17 Jun 2014 09:10:15 GMT

Then you can use If else if with multiple conditions

if condition1 then

[ statements ]

{

elseif condition2 then

[ statements ] }

[ else

[ statements ] ]

end if

Re: edit expression

its_anandrjs — Tue, 17 Jun 2014 09:17:56 GMT

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

];

Re: edit expression

Tue, 17 Jun 2014 09:23:57 GMT

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.

Re: edit expression

anbu1984 — Tue, 17 Jun 2014 10:04:29 GMT

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

Re: edit expression

its_anandrjs — Tue, 17 Jun 2014 10:09:12 GMT

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