topic Re: Surely this is a simple fix... in QlikView

Surely this is a simple fix...

Thu, 05 Mar 2015 11:42:50 GMT

...I just can't seem to figure it out!

I have two fields, BeautyParadeDate and SiteVisitDate.

I'd like to do the following;

If both fields are blank then state "Tender", else, state BeautyParade or SiteVisit dependant on which date is greater.

For some reason I cannot get this to work

Can anyone help please?

Re: Surely this is a simple fix...

Anonymous — Thu, 05 Mar 2015 11:44:48 GMT

Samuel,

Is this an script issue or are you stacked building an expression? Please post sample as well.

Marc.

Re: Surely this is a simple fix...

Thu, 05 Mar 2015 11:47:47 GMT

I'm trying to achieve it within the script, I've literally got one line of data at the moment with two fields!

Beauty Parade Date	Site Visit Date
	03/02/2015

If they are both blank then "Tender" else state the one with the max date. The result of the above should say "Site Visit"

Re: Surely this is a simple fix...

sunny_talwar — Thu, 05 Mar 2015 11:48:38 GMT

Maybe this:

Alt(If(BeautyParadeDate > SiteVisitDate, BeautyParadeDate, SiteVisitDate), 'Tender') as SiteVisit

If(IsNull(BeautyParadeDate) and IsNull(SiteVisitDate), 'Tender', If(BeautyParadeDate > SiteVisitDate, BeautyParadeDate, SiteVisitDate)) as SiteVisit

HTH

Best,

Re: Surely this is a simple fix...

sunny_talwar — Thu, 05 Mar 2015 11:54:47 GMT

Tested the following code with some dummy data and it seems to work just as you wanted:

Table:

LOAD * INLINE [

BeautyParadeDate, SiteVisitDate

01/01/2015, 12/31/2014

03/15/2013, 06/15/2013

];

Table2:

LOAD *,

Alt(If(BeautyParadeDate > SiteVisitDate, BeautyParadeDate, SiteVisitDate), 'Tender') as SiteVisit

Resident Table;

Best,

Re: Surely this is a simple fix...

Thu, 05 Mar 2015 11:59:32 GMT

Must be something odd going on then as I tried these solutions before and all I get is Tender, for some reason the dates are being ignored

Re: Surely this is a simple fix...

sunny_talwar — Thu, 05 Mar 2015 12:01:18 GMT

May be the dates you are using are picked up by QlikView as text instead of date. You might want to use Date# function if that is the case.

Best,

Re: Surely this is a simple fix...

manojkulkarni — Thu, 05 Mar 2015 12:13:09 GMT

As suggested by sunindia, it is working. Please could you add sample code here which you are using .

Re: Surely this is a simple fix...

Fri, 06 Mar 2015 11:37:05 GMT

Nothing seemed to work with this so I had to build a separate indicator field for each status and work it out from there. Thanks anyway people