topic Script in QlikView

Script

Thu, 26 Nov 2015 09:27:25 GMT

Hi All

i want to a submission status list to show the list of the following: "submitted","to be submitted" and not submitted

I have this script that is suppose to do the above but is showing only the "submitted" and "to be submitted"

if([CV Send Date]=[Closing date] ,'Submitted'

, if( ( [Closing date] < Today() )and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) ),'Not Submitted'

, if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Thanks and Regards

Priscilla

Re: Script

t_chetirbok — Thu, 26 Nov 2015 13:00:16 GMT

Hello!

Can you write table with some data for example.

Thnks

Re: Script

Anonymous — Thu, 26 Nov 2015 13:08:52 GMT

Try this:

Bold bracket need to be closed in last...

if([CV Send Date]=[Closing date] ,'Submitted' ,

if( ([Closing date] < Today() and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) )),'Not Submitted' , if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Re: Script

Mark_Little — Thu, 26 Nov 2015 13:13:49 GMT

Hi,

Some data maybe handy, but when i used isNull() i will always check IsNull()=-1, -1 is null 0 is not null

Mark

Re: Script

Thu, 26 Nov 2015 13:39:42 GMT

i am not good at using this message box but whant is a list of status e.g

Submission Status

Submitted

Not Submited

To be ubmitted

if([CV Send Date]=[Closing date] ,'Submitted'

, if( ( [Closing date] < Today() )and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) ),'Not Submitted'

, if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Re: Script

Thu, 26 Nov 2015 13:46:25 GMT

i dont know how to draw table but maybe you will get an idea:

I want a list box of submission status it must be like this:

Submission status (this is a title)

Submitted

Not Submitted

To be Submitted

and this script is giving me only two status, Submitted and to be Submitted

if([CV Send Date]=[Closing date] ,'Submitted' ,

if( ([Closing date] < Today() and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) )),'Not Submitted'

, if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Re: Script

Thu, 26 Nov 2015 14:01:11 GMT

The null i am referring to is an empty cell in a spread sheet,

Re: Script

Thu, 26 Nov 2015 14:03:57 GMT

it is still the same

Re: Script

t_chetirbok — Thu, 26 Nov 2015 14:07:07 GMT

ok, maybe when you write if conditions for 'Not Submitted' , try this: (IsNull( [Candidate FullName]) or [Candidate FullName]='') and (IsNull([CV Send Date]) or [CV Send Date]=0).

and for "Submitted": [CV Send Date]<=[Closing date]

If it's not right, post your filed with some data.

Re: Script

Thu, 26 Nov 2015 14:07:24 GMT

is still not giving me the three status on the list box but two

only Submitted and to be submitted

Re: Script

syukyo_zhu — Thu, 26 Nov 2015 14:12:52 GMT

Hi,

are you sur that [Candidate FullName] or [CV Send Date] is null? could it be ''

Re: Script

Thu, 26 Nov 2015 14:19:30 GMT

Yes there are fields that are empty in the spread sheet so if candidate name is empty it means the CV was not sent and that make the CV sent date empty.the closing date is always there.

Re: Script

maxgro — Thu, 26 Nov 2015 18:04:34 GMT

sometimes you have to replace the IsNull

with len(trim(field))=0 to ckech for empty values

example

if(len(trim([CV Send Date]))=0, ' CV is null', 'CV is not null')

Re: Script

Fri, 27 Nov 2015 07:59:11 GMT

this one is working well but it is returning wrong value instead of 40 it is returning 39

if( ( len(trim([Candidate FullName]))>0),'Submitted'

the number of candidates names are 40 in the spread sheet but its returning only 40

Re: Script

maxgro — Fri, 27 Nov 2015 18:35:44 GMT

could you post the spreadsheet?