Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
create a date field and use avg as expression
regards
Sorry, but i don't Need the avg, i want to multiplicate the single values grouped by each column of the Dimension...
Hi,
You can use Aggr function for this:
Sum(Values)* Aggr(MultiplierValue,Dim2,Dim1)
HTH
Sushil
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