Qlik (Sense) is not using dimensions for calculation

[sirpod90]

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	StepName-1-V
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!

[sirpod90]

It just means, that the ID is devided by 10 to the power 10

ID / 10000000000

So that the first parameter (Date/Time) weight more than the ID.