Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - count values for latest possible date

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'.

28-04-2014 12-47-31.jpg

Could you please help?

9 Replies
MK_QSL
MVP
MVP

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.

Not applicable
Author

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

Not applicable
Author

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
MVP
MVP

Try

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

Not applicable
Author

Hi Manish ,

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

regards

Darek

PradeepReddy
Specialist II
Specialist II

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

Not applicable
Author

Pradeep,

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

regards

Darek

Not applicable
Author

Nikita,

i think v1 should work

Let me know if it meets your requirements...

regards

Darek

Not applicable
Author

??