Set analysis - count values for latest possible date

[#1]

Hi everyone,

I am working on the project tracker and updating status of individual projects through collection of XLS detaileded workplans. Not every project will be updated reguarly. I created signle table to summarize the latest status of all initiatives using FirstSortedValue(Task, - Date). Now I am having difficulties to write set analysis formula to count tasks by status for latest date within Task where version = 'Actual'.

Could you please help?

[MK_QSL]

You can create a flag where Task = 'actual' in the script itself.

But, if you can provide little data, would be helpful us to give you answer.

[#3]

Nikita,

i answered for similiar question in this thread:

http://community.qlik.com/thread/114737

take a look and let me know if it helps and solves this question.

regaards

Darek

[#4]

Darek,

Thanks for your hellp to create the table. I now want to create textbox which will show number of tasks in the latest project update and below is what I have currently in mind:

= count({<Date='=aggr(max(Date),Task)', Status={'Completed', 'In progress'}>} Tasks)

This however returns wrong number of tasks

[MK_QSL]

Try

Aggr(Count({$<Date = {'$(=Max(Date))'}, Status = {'Completed', 'In progress'}>}Tasks),Tasks)

[#6]

Hi Manish ,

i remember, that each Nikitas project (TaskId) has own history (own max date)....

regards

Darek

[PradeepReddy]

Hi,

Interesting scenario.

I have tried  using the set analysis, but did n't get the solution.

I think in script level we can achieve this.

Take only one entry for each Taskid along with the latest date status (Temp table).

Then we can calculate the count as required.

Thanks,

Pradeep

[#8]

Pradeep,

of course, it is easy on script level. But what with user selections?

regards

Darek

[#9]

Nikita,

i think v1 should work

Let me know if it meets your requirements...

regards

Darek

[#10]

??