Problem with aggregation

Wed, 02 Jul 2014 09:56:59 GMT

Hi, I have a source table as presented below :

Portfolio	Node	Task	Date
Commercial	Project 1	A	12-11-12
Commercial	Project 1	B	10-05-13
Commercial	Project 2	A	15-12-12
Financial	Project 3	A	23-04-11
Financial	Project 4	A	22-01-10
Financial	Project 4	B	11-08-14

now i want to create this tabke :

Portfolio	Node	Date
Commercial	Project 1	12-11-12
Commercial	Project 2	15-12-12
Financial	Project 3	23-04-11
Financial	Project 4	22-01-10

As you can see I want to assign just one date to each Node - date from Task 'A'. I don't have any idea how to solve that. I can't just use if(Task='A', Date) and hide null values because i have to do similar thing in another column. Any idea ?

Re: Problem with aggregation

hic — Wed, 02 Jul 2014 10:06:15 GMT

If you do this as a Pivot Table, you can use Portfolio and Node as dimensions, and

Date(Min( {$<Task={'A'}>} Date))

as expression.

HIC

Re: Problem with aggregation

pradnyat — Wed, 02 Jul 2014 10:23:02 GMT

Hi,

Please find the attached file for the issue.

Hope this will help you...!

topic Problem with aggregation in QlikView

Problem with aggregation

Re: Problem with aggregation

Re: Problem with aggregation