topic Re: Max(Sum(x)) ?? in App Development

Max(Sum(x)) ??

ascioneanna — Fri, 07 Jul 2017 09:50:56 GMT

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.

Re: Max(Sum(x)) ??

sunny_talwar — Fri, 07 Jul 2017 11:13:40 GMT

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))

Re: Max(Sum(x)) ??

kaanerisen — Fri, 07 Jul 2017 11:15:29 GMT

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))

Re: Max(Sum(x)) ??

ascioneanna — Fri, 07 Jul 2017 12:49:09 GMT

Thank you very much It work

Re: Max(Sum(x)) ??

ascioneanna — Fri, 07 Jul 2017 12:57:21 GMT

thabnk you Now works