4 Replies Latest reply: Jul 7, 2017 8:49 AM by Annamaria Ascione RSS

    Max(Sum(x)) ??

    Annamaria Ascione

      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.