topic Re: Null value to be shown in QlikView

Null value to be shown

Anonymous — Mon, 20 Nov 2017 15:06:53 GMT

Hi Experts,

Need some assistance in finding null value with mixed dates.

For example

Employee1	JoiningDate
1	20-11-2017
2	19-11-2017
3

Desired Output : Null

Scenario 2 :

Emplooye1	JoiningDate
1	20-11-2017
2	19-11-2017
3	18-11-2017

Desired Output : 20-11-2017

Joining date should be either Max if all the date are available else if it holds Null at any stage show Null

In-advacne

Thank u

Message was edited by: satya reyansh

Re: Null value to be shown

Miguel_Angel_Baeyens — Mon, 20 Nov 2017 15:10:04 GMT

Why the scenario 2, which has data for Employee1 should be ignored and display 20.11.2017 instead? Which other fields and criteria apply in your expressions and data model?

Re: Null value to be shown

Anonymous — Mon, 20 Nov 2017 15:13:54 GMT

I had given 2 sample sets saying with Scenario.

For example if I Hold one Min date ,Max date and Null then it has to pick Null .

If Employee have all records its has to show max date.

No criteria in data model.

Re: Null value to be shown

Anil_Babu_Samineni — Mon, 20 Nov 2017 15:18:48 GMT

Perhaps this?

If(IsNull(JoiningDate), 'NULL', Max(JoiningDate))

Re: Null value to be shown

Anonymous — Mon, 20 Nov 2017 15:30:50 GMT

I tired the same previously but no luck ,its working on simple set of data.

In my case it falling:

If(IsNull(Joining_Date), 'NULL',

Max(if(GetSelectedCount(Employee_ID),Date(Joining_Date), if(product_activity_name=job_activity_group,Date(Joining_Date))))).

No worreis ur sollution is very helpful.I thing there is an issue in date converstion in Script level itself.Myself i have to check.Thanks for the time

Re: Null value to be shown

Anil_Babu_Samineni — Tue, 21 Nov 2017 07:07:11 GMT

I believe not the problem with the Date format, Because there is 2 conditions in your statement that means 2 statements needed to Max value. So, I would think this

If(IsNull(Joining_Date), 'NULL',

RangeMax(if(GetSelectedCount(Employee_ID),Date(Joining_Date), if(product_activity_name=job_activity_group,Date(Joining_Date)))))

Note - Please close this thread using correct answer. Meantime, Read this Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Null value to be shown

vlakeshr — Fri, 29 Dec 2017 08:28:04 GMT

You can clk on highlighted option once apply your condition. Please check