topic Re: How to write If statement in script level in QlikView

How to write If statement in script level

Srinivas — Mon, 03 Mar 2014 09:29:18 GMT

Hi Everybody.

I have tried one logic but i did't get exact value, My script is below

If the Type = X, multiply the sales * -1, insert the amount into Rebates LC and set sales to 0.....

here Type , Sales, Rebates all are different fields,

Thanks in Advance

Munna@

Re: How to write If statement in script level

Peter_Cammaert — Mon, 03 Mar 2014 09:32:44 GMT

IF (Type='X', 0, Sales) AS Sales,

IF (Type='X', Sales * (-1), 0) AS [Rebates LC],

Best,

Peter

Re: How to write If statement in script level

er_mohit — Mon, 03 Mar 2014 09:34:20 GMT

try this

if(Type='X',(Sales*(-1)),Rebates)

Re: How to write If statement in script level

alexandros17 — Mon, 03 Mar 2014 09:36:16 GMT

SELECT (or LOAD)

...

if(Type= 'X', Sales * -1, Sales) as [Rebates LC],

if(Type= 'X', 0, Sales) as Sales,

...

Re: How to write If statement in script level

MK_QSL — Mon, 03 Mar 2014 09:53:22 GMT

Load

your fields,

If(Type = 'X', sales*-1) as [Rebates LC],

if(Type = 'X', 0, sales) as sales;

From TableName;

Re: How to write If statement in script level

Fri, 30 May 2014 15:52:21 GMT

HELP PLEASE

Why does the IF portion not work ??

ODBC

CONNECT32 TO QED208;
SQL SELECT dtcrash as crash_dtcrash,
crashnum as crash_crashnum,
month(dtcrash) as crash_month,
year(dtcrash) as crash_year,
loctype as crash_locationtype,
hrmfeventdesc2 as crash_desc,
weathcond1desc as crash_weather,
roadsurfdesc as crash_roadsrufacecond,
manrcolldesc as crash_mandesc,
rdwyjuncdesc as crash_rdyjunction,
intrdwy1name as crash_road1,
intrdwy2name as crash_road2,
nointstnum as crash_stnum,
nointstname as crash_street,
hrmfeventcode2 as crash_hrmfeventcode2
FROM uqed.xacreports where ((date(dtcrash) >= (40909)));

SELECT if(nointstnum >'',nointstname,road1) as crash_location;

Re: How to write If statement in script level

PrashantSangle — Fri, 30 May 2014 16:10:36 GMT

Hi,

Try your if with load Statement instead of Select Statement.

ODBC

CONNECT32 TO QED208;

Test1:

SQL SELECT dtcrash as crash_dtcrash,
crashnum as crash_crashnum,
month(dtcrash) as crash_month,
year(dtcrash) as crash_year,
loctype as crash_locationtype,
hrmfeventdesc2 as crash_desc,
weathcond1desc as crash_weather,
roadsurfdesc as crash_roadsrufacecond,
manrcolldesc as crash_mandesc,
rdwyjuncdesc as crash_rdyjunction,
intrdwy1name as crash_road1,
intrdwy2name as crash_road2,
nointstnum as crash_stnum,
nointstname as crash_street,
hrmfeventcode2 as crash_hrmfeventcode2
FROM uqed.xacreports where ((date(dtcrash) >= (40909)));

Test2:
Load *,if(nointstnum >'',nointstname,road1) as crash_location

Resident Test1;

Drop tables Test1;