Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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!
It worked! Thanks so much 🙂