Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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?

Tags (1)
9 Replies

Re: Set analysis - count values for latest possible date

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

Re: Set analysis - count values for latest possible date

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

Re: Set analysis - count values for latest possible date

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

Re: Set analysis - count values for latest possible date

Try

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

Not applicable

Re: Set analysis - count values for latest possible date

Hi Manish ,

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

regards

Darek

pradeepreddy
Valued Contributor II

Re: Set analysis - count values for latest possible date

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

Re: Set analysis - count values for latest possible date

Pradeep,

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

regards

Darek

Not applicable

Re: Re: Set analysis - count values for latest possible date

Nikita,

i think v1 should work

Let me know if it meets your requirements...

regards

Darek

Not applicable

Re: Re: Set analysis - count values for latest possible date

??

Community Browser