Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.