Multiplication of single values

[Anonymous]

Hello community,

i need one more time your help 🙂

i have a Diagramm (1.Dimension = month_day_hour; 2. Dimension = Process; Expresion = Output/Input (%), so i get following result:

But i Need (want) to multiplicate the single Values for all processes over one month_day_hour, to get the trend...

Is it posible with Qlik View?

Thanks in advance!!!

[martinpohl]

create a date field and use avg as expression

regards

[Anonymous]

Sorry, but i don't Need the avg, i want to multiplicate the single values grouped by each column of the Dimension...

[sushil353]

Hi,

You can use Aggr function for this:

Sum(Values)* Aggr(MultiplierValue,Dim2,Dim1)

HTH

Sushil

[Anonymous]

Hello Sushil,

I've tried it, but it doesn't work.

1.) What is "MultiplierValue"? Is this a function?

2.) Dim2, Dim1 are the Dimensions, right? What is if my Dim1 is a dynamic Dimension?

Tahnak in advance.

Alin