Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Curiosity
New Contributor

Transforming DAX Syntax into Qlikview Script

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!

Labels (4)
1 Solution

Accepted Solutions
hector
Valued Contributor

Re: Transforming DAX Syntax into Qlikview Script

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!

2 Replies
hector
Valued Contributor

Re: Transforming DAX Syntax into Qlikview Script

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
New Contributor

Re: Transforming DAX Syntax into Qlikview Script

It worked! Thanks so much 🙂