How to create 3 values from one date field variable

[#1]

Hi All ,

Would it be possible to create 3 values from one date filed.what I am expecting here

If date field is null show as Pend , if date field is not null show as complete and want to show if date field is total as Recieved

This is expecting

if(isnull(date ),'Pend',if(not Is null(date),'complete ',if(isnull(date)and if (is not null(date),'received') as newfield

I am able to getting two values that Pend ,complete

How to get two values total as received

Please guide me how to do it

[sunny_talwar]

Your 3rd condition: if(isnull(date)and if (is not null(date),'received')

How can date be null and not null at the same time?

[marcus_malinow]

It could be a quantum date

[syukyo_zhu]

Hi,

Try this, but i'm not sur this is according your request

if(isnull(date ),'received-Pend','received-complete') as newfield

[#5]

Orelse want to see total count as Received I need three values , null , not null and both count

[#6]

I need two separate values and both count , three values I am expecting

[qlikviewwizard]

Hi,

Try this.

if(isnull(date ),'Pending',if(not Is null(date),'complete ',if(isnull(date) and  is not null(date),'received')

[Digvijay_Singh]

How 'date' can be null and not null at the same time, I think third condition need to be explained better

[#9]

I can see only 2 values which are Pend and complete ,not able to getting Received.i want to achieve pend ,complete and Received.Assume Received as both values total

[Anonymous]

Hi,

You ask "How to get two values total as received".  Do you mean that you have 2 date fields ?

Otherwise, like already mentioned, a date cannot be null() and not null() at the same time.