topic Re: Can someone help me to do the script for the query below?? in QlikView

Can someone help me to do the script for the query below??

Tue, 21 Jan 2014 05:29:40 GMT

Hi,

Can someone help me to script the query below?

I have 3 fields to use for this script.

1. Document Number

2. Approved Date

3. Release Date

Query: I wanted to get the month created (this could be approved date or release date). The problem is some of the rows of approved date are blanks. I wanted to get the released date insted for those blanks in approved date. How to do this script? Im not sure if if else statement would be fit for this.

Thank you..

Re: Can someone help me to do the script for the query below??

whiteline — Tue, 21 Jan 2014 05:35:26 GMT

LOAD

[Document Number],

if(not isnull([Approved Date]), Month([Approved Date]), Month([Release Date])) as [Release Month]

FROM ...

Re: Can someone help me to do the script for the query below??

CELAMBARASAN — Tue, 21 Jan 2014 05:48:30 GMT

Try like this

LOAD

DocumentNumber,

Month(If(Len(ApprovedDate) > 0, ApprovedDate, ReleaseDate)) AS Month

// if it is really date field, try Month(Alt(ApprovedDate, ReleaseDate)) AS Month

FROM DataSource

Re: Can someone help me to do the script for the query below??

Anonymous — Tue, 21 Jan 2014 05:53:30 GMT

The Alt() function is the best solution to your problem as it replaces any null values with the field in your first argument with your specified second argument.

Re: Can someone help me to do the script for the query below??

Tue, 21 Jan 2014 14:08:04 GMT

Try like below:

LOAD [Document Number] ,

Month( ALT(Release_date,Approved_date)) AS Released_Month

FROM ,,,,;

Re: Can someone help me to do the script for the query below??

Wed, 22 Jan 2014 00:48:57 GMT

Hi,

It worked! Helped a lot

Thank you!!

Re: Can someone help me to do the script for the query below??

Wed, 22 Jan 2014 00:50:05 GMT

Hi Whiteline,

Thanks for this script. It helped too

Re: Can someone help me to do the script for the query below??

Wed, 22 Jan 2014 00:51:15 GMT

Yes, is used Alt and worked. Thanks!

Re: Can someone help me to do the script for the query below??

Wed, 22 Jan 2014 00:52:01 GMT

Thank you!