topic Re: How to use if then statement to create new column in QlikView

How to use if then statement to create new column

Tue, 06 May 2014 08:33:44 GMT

Hi, how do i create a column called 'before 10am' using if then statement? The underlined part has error.

LOAD * INLINE [

Before 10am

];

if([Time]<='10:00:00') then ([Before 10am]=1);

Thanks.

Re: How to use if then statement to create new column

jsingh71 — Tue, 06 May 2014 08:37:31 GMT

try this

if([Time] <= '10:00:00',([Before 10am]=1))

Re: How to use if then statement to create new column

tresB — Tue, 06 May 2014 08:37:44 GMT

Do you want the value of the field to be set '1' or '0', if so then try like:

load

If( yourcondition, 1,0) as [Before 10am]

Re: How to use if then statement to create new column

alexandros17 — Tue, 06 May 2014 08:37:52 GMT

MYTAB:

LOAD * INLINE [

Name

John

Luis

Alex

];

Load

if(Name = 'Alex', 'Alex The Great', Name) as newName

resident MYTAB;

Drop Table MYTAB;

Hope it helps

Re: How to use if then statement to create new column

preminqlik — Tue, 06 May 2014 08:47:44 GMT

elaborate the question , i think you need to create a coumn in front end or backend then you directly use maketime(hh,m,ss)

like below :

in script:

if([Time]<=maketime(10,0,0) ,1,0) as Before10am

in front end expression :

if([Time]<=maketime(10,0,0) ,1,0)

Re: How to use if then statement to create new column

Tue, 06 May 2014 08:59:55 GMT

Sorry, none of the answers worked. I want the column 'before 10am' to be 1 if the column 'time' is >=10:00:00, else it will be 0. Thanks.

Re: How to use if then statement to create new column

Tue, 06 May 2014 09:07:20 GMT

Hi,

Try this..

Load

if(Timestamp(time,'hh:dd:ss')>'10:00:00',1,0) as [before 10am]

From <YourTable> ;

Thanks,

Prabhu

Re: How to use if then statement to create new column

anbu1984 — Tue, 06 May 2014 09:08:28 GMT

If( Time >= '10:00:00' , 1,0) as [Before 10am]

Re: How to use if then statement to create new column

rbecher — Wed, 07 May 2014 13:00:41 GMT

Hi Rachel,

I would use:

LOAD

if( time#([Time], 'hh:mm:ss') < time#('10:00:00', 'hh:mm:ss'), 'Before 10am') as TimeBefore10am

...

FROM

- Ralf