Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ascioneanna
New Contributor III

Max(Sum(x)) ??

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.

1 Solution

Accepted Solutions
kaanerisen
Contributor III

Re: Max(Sum(x)) ??

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

ss_order.png

4 Replies

Re: Max(Sum(x)) ??

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
Contributor III

Re: Max(Sum(x)) ??

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

ss_order.png

ascioneanna
New Contributor III

Re: Max(Sum(x)) ??

Thank you very much It work

ascioneanna
New Contributor III

Re: Max(Sum(x)) ??

thabnk you Now works

Community Browser