Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ascioneanna
Contributor III
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
Creator III
Creator III

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

View solution in original post

4 Replies
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
Creator III
Creator III

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

Thank you very much It work

ascioneanna
Contributor III
Contributor III
Author

thabnk you Now works