topic Transforming DAX Syntax into Qlikview Script in QlikView

Transforming DAX Syntax into Qlikview Script

Curiosity — Sat, 16 Nov 2024 20:07:09 GMT

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!

Re: Transforming DAX Syntax into Qlikview Script

hector — Tue, 10 Sep 2019 18:25:13 GMT

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!

Re: Transforming DAX Syntax into Qlikview Script

Curiosity — Wed, 11 Sep 2019 10:55:57 GMT

It worked! Thanks so much 🙂