topic Re: For summarizing values in Qlik Automate

For summarizing values

Ns7703 — Tue, 23 Jul 2024 10:28:24 GMT

all total costs (GESAMTKOSTEN) for the selected project and coarse structuring (GROBGLIEDERUNG) = "Fremd" and fine structuring (FEINGLIEDERUNG) = "Lieferant/extern" and commercial closed Status (KFM_ABGESCHLOSSEN) are summarized . How do we write expression for this In (KFM_ABGESCHLOSSEN) field we only have two values Nein and ja . So how we write the expression.

Re: For summarizing values

kamadoki — Tue, 06 Aug 2024 10:32:25 GMT

Power query your table/range. You can split the column by delimiter. An advanced option will let you split the column into rows. The delimiter is comma. Trim the blank leading space from History and your pivot table will read 1 Female in CS and 1 Female in History. Even though they are both Stacy, that doesn’t matter because she counts as one for each.