Max(Sum(x)) ??

[ascioneanna]

Hi,

I'm working on a qliksense document. I need to create a measure to calculate %Order. But i defined a variable because i work for different period

I have defined:

Number of Orders =sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),[Order State 2]={'Confermato'}>}[Numero Ordini]).

I want to calculate %Ordini making the raport between Number of Orders / max(Number of Orders). This is a formula that i used but it doasen't work.

Someone can help me?

%Orders=Number of Orders /max(Number of Orders)

--> because i work with a variable

sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),[Order State 2]={'Confermato'}>}[Numero Ordini])

/max(Total sum(num(num#({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),[Order State 2]={'Confermato'}>}[Numero Ordini])))) ! !

I attach the qliksense app and the picture of what I want to replicate with qliksense.

[sunny_talwar]

May be try this

Sum({<[Client ID] = p({<[Periodo Primo Ordine] = {'$(vMeasure)'}>}), [Order State 2] = {'Confermato'}>} [Numero Ordini])

/Max(TOTAL Aggr(Sum({<[Client ID] = p({<[Periodo Primo Ordine] = {'$(vMeasure)'}>}), [Order State 2] = {'Confermato'}>} [Numero Ordini]), Periodo))

[kaanerisen · Accepted solution]

Hello Annamaria,

% ordini iniziali:

sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),[Order State 2]={'Confermato'}>}[Numero Ordini])

/

max(total aggr(sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),[Order State 2]={'Confermato'}>}[Numero Ordini]),Periodo))

% clienti iniziali:

sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),Periodo={'>=$(vMeasure)'}>}[Numero Clienti])

/

max(total aggr(sum({<[Client ID]=p({<[Periodo Primo Ordine]={'$(vMeasure)'}>}),Periodo={'>=$(vMeasure)'}>}[Numero Clienti]),Periodo))

[ascioneanna]

Thank you very much It work

[ascioneanna]

thabnk you Now works