topic Re: Date Filtering Issue in QlikView

Date Filtering Issue

kakani87 — Thu, 11 Jan 2018 07:16:28 GMT

Dear All,

I'm having two fields with me like LiveEntryDate and Emp, now my requirement is to display the list of people liveentrydate less than max liveentrydate and this is showing the list exactly.

Max({<LiveTrackEntryDate,EmpName=p({<LiveTrackEntryDate={'>$(=date(max(LiveTrackEntryDate),-1)) <$(=date(max(LiveTrackEntryDate)))'}>})>*<LiveTrackEntryDate,EmpName=e({<LiveTrackEntryDate={'$(=If(getselectedcount(LiveTrackEntryDate),max(LiveTrackEntryDate),max(LiveTrackEntryDate)))'}>})>}LiveTrackEntryDate)

Now the issue is with the filter that when i filter the liveentrydate the data is not populating correctly

i.e lets say if we filter for livedateentry 0n 07/01/2018 this is showing greater than the date records as well.

can any one help me.

Shared image is with out filtering correct data and second is filtered show ing wrong .

Re: Date Filtering Issue

Anil_Babu_Samineni — Thu, 11 Jan 2018 07:29:14 GMT

Could be problem here

Re: Date Filtering Issue

kakani87 — Thu, 11 Jan 2018 11:48:03 GMT

Not working Anil