Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create 3 values from one date field variable

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

31 Replies
Not applicable
Author

I am able to get the proper values when I am use the following expression

=if(Flag='Received',count(ID),if(Flag='Complete',count({<Null_Flag={0}>}ID),
if(Flag='Pending',count({<Null_Flag={1}>}ID))))

dimension: Flag

don't know is this proper approach or not ?

see the below image

 

sunny_talwar

Would it be possible to share a sample to show the issue?