Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
qlikview2015
Contributor

Set Analysis + AGGR

Hallo zusammen,

ich würde gerne in dieser Formel die Dimension mitgeben für die gerechnet werden soll. Leider bekomme ich die Syntax nicht hin. Könnt ihr mir helfen?

=Sum({$<Artikelpostenart = {"Istmeldung"}>} Artikelpostenmenge)

Die Dimension wäre Beispielsweise "[FA-Nr.]".

Vielen Dank im vorraus.

Mike

Tags (2)
9 Replies
qlikview2015
Contributor

Re: Set Analysis + AGGR

Hat keiner eine Idee?

MVP
MVP

Re: Set Analysis + AGGR

What exactly you want to do?

qlikview2015
Contributor

Re: Set Analysis + AGGR

There are many other Dimensions in the Diagramm, but I want only to sum the [Artikelpostenmenge] with the Dimension [FA-Nr.], if Artikelpostenart = Istmeldung.

MVP
MVP

Re: Set Analysis + AGGR

What is meaning by with the Dimension [FA-Nr.]?

qlikview2015
Contributor

Re: Set Analysis + AGGR

[FA-Nr.] is the Dimension for the sum.

MVP
MVP

Re: Set Analysis + AGGR

is that dimension name or dimension value?

Re: Set Analysis + AGGR

Not sure, but may be this:

=Sum(TOTAL <[FA-Nr.]> {$<Artikelpostenart = {"Istmeldung"}>} Artikelpostenmenge)

qlikview2015
Contributor

Re: Set Analysis + AGGR

The name

qlikview2015
Contributor

Re: Set Analysis + AGGR

I will try it in the next few days and give an answer.