Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview2015
Creator II
Creator II

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

9 Replies
qlikview2015
Creator II
Creator II
Author

Hat keiner eine Idee?

MK_QSL
MVP
MVP

What exactly you want to do?

qlikview2015
Creator II
Creator II
Author

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

MK_QSL
MVP
MVP

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

qlikview2015
Creator II
Creator II
Author

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

MK_QSL
MVP
MVP

is that dimension name or dimension value?

sunny_talwar

Not sure, but may be this:

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

qlikview2015
Creator II
Creator II
Author

The name

qlikview2015
Creator II
Creator II
Author

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