Hello everybody,
I am running at the moment in really weird problem and can not come up with any conclusions.
My Data looks like that:
| Container-Name | Action-Date | Step-Name |
|---|
| Container12 | 01.01.2016 | StepName-1 |
| Container12 | 02.01.2016 | StepName-2 |
| Container12 | 03.01.2016 | StepName-3 |
| Container12 | 04.01.2016 | StepName-1-V |
| Container43 | 01.01.2016 | StepName-A |
| Container43 | 01.01.2016 | StepName-B |
I want to have table with the max step name the container past in time
So my result should look like that:
| Container-Name | Action-Date | Step-Name |
|---|
| Container12 | 04.01.2016 | StepName-1-V |
| Container43 | 01.01.2016 | StepName-B |
I set up a table with Container-Name as dimension and AGGR(max(Action-Date), Container-Name) as second dimension. If I now add the fact MaxString(Step-Name) the result looks for max string in all containers and not with the maximum date.
So my result looks like that:
| Container-Name | Action-Date | Step-Name |
|---|
| Container12 | 04.01.2016 | StepName-3 |
| Container43 | 01.01.2016 | StepName-B |
It seams like the fact column would ignore the two dimensions before hand?
Why?? Do I have a wrong understanding of dimensions and facts?
When I tried to solve the problem with set analysis and only the container as dimension:
maxstring({$<Action-Date= {'&(=max(Action-Date))'}>}StepName)
My result where right but just for one Container, so Qlik took the max-Date from all dates, ignoring the dimension again.
| Container-Name | Step-Name |
|---|
| Container12 | |
| Container43 | - |
I also tried to combine the set analysis with AGGR but the result is still wrong.
Is there something I really miss or does Qlik have a problem?
I am thank full for any help.
Regards!
