topic Re: Finding the Recent date in Chart Object in QlikView

Finding the Recent date in Chart Object

sudhir0538 — Fri, 24 Nov 2017 03:59:58 GMT

Hello Community,

I have a data where a medical team visiting different places for medical camps,there's a possibility that they can visit already visited place twice or thrice and so on.. and they are maintaining a visited date column.

My requirement is to display the last visited date against the location in a straight table. how can I achive this?

the data will be displayed like the above and the village NISHA visited twice on 26-09-2017 and 12-09-2017 so in the last visited date column it should display 12-09-2017 against 26th visited date and on 12th it should display the same date,because it's the first visit for that location.

Re: Finding the Recent date in Chart Object

devarasu07 — Fri, 24 Nov 2017 04:14:20 GMT

Hi,

Try to create Cal. dimension like below,

=aggr(Date(max(Date),'DD-MM-YYYY'),Name)

Re: Finding the Recent date in Chart Object

sudhir0538 — Fri, 24 Nov 2017 04:50:48 GMT

Hi Devarasu,Thank you!

I already tried this earlier, it's giving correct result for the non first visit and failed for first visit. Please look at the result for NISHA.

For 2nd record the 12-09-2017 needs to be appeared.

Re: Finding the Recent date in Chart Object

jonathandienst — Fri, 24 Nov 2017 05:41:35 GMT

Still not clear what you require. Please provide a full sample (not an image) with the visit date, village name and required value for last visit.

Re: Finding the Recent date in Chart Object

sudhir0538 — Thu, 30 Nov 2017 10:32:59 GMT

Hello Jonathan and Devarasu,I am very sorry the solution which I did earlier and what you proposed are same and it's suffice for this requirement.

Due to the lack of clarity in FS doc I got confused and made you guys confused.

Thank you so much for the help!!