Transforming DAX Syntax into Qlikview Script

[Curiosity]

Hello Guys and Gals

I have a short DAX Script that I would like to have as a variable in Qlikview Script. Can somebody help me with the Transformation?

Umsatz TD:=CALCULATE(
    SUM(fakten_wkn[metric]);
    fakten_wkn[type]="Umsatz";
    FILTER (
         ALL (
            dim_datum[datum]
        );
        dim_datum[datum] <= MAX (dim_datum[datum]
        )
    ) 
 
)

The variable should look like this (this is the first 3 lines translated from DAX):

SET vUmsatzTD = SUM({<[type] ={'Umsatz'}>} [metric]);

Thanks and Greetings!

[hector · Accepted solution]

Hi

I'm not quite sure, but maybe something like this

SUM({<[type] ={'Umsatz'}, datum = {"<=$(=Max(datum))"}>} [metric]);

if datum has a numeric value

hope it helps!

[Curiosity]

It worked! Thanks so much 🙂