topic Re: Set analysis - count values for latest possible date in QlikView

Set analysis - count values for latest possible date

Mon, 28 Apr 2014 08:53:58 GMT

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?

Re: Set analysis - count values for latest possible date

MK_QSL — Mon, 28 Apr 2014 08:56:58 GMT

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.

Re: Set analysis - count values for latest possible date

Mon, 28 Apr 2014 08:58:30 GMT

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

Re: Set analysis - count values for latest possible date

Mon, 28 Apr 2014 09:13:04 GMT

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

MK_QSL — Mon, 28 Apr 2014 09:15:24 GMT

Try

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

Re: Set analysis - count values for latest possible date

Mon, 28 Apr 2014 09:24:42 GMT

Hi Manish ,

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

regards

Darek

Re: Set analysis - count values for latest possible date

PradeepReddy — Mon, 28 Apr 2014 11:07:50 GMT

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

Re: Set analysis - count values for latest possible date

Mon, 28 Apr 2014 11:18:12 GMT

Pradeep,

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

regards

Darek

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

Mon, 28 Apr 2014 18:07:28 GMT

Nikita,

i think v1 should work

Let me know if it meets your requirements...

regards

Darek

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

Mon, 05 May 2014 20:42:40 GMT