0 Replies Latest reply: Jul 17, 2014 5:51 AM by Lander Uriarte RSS

    Some help with first and last on count({set analysis} DISTINCT aggr(firstsortedvalue)))

    Lander Uriarte

      Hi!

       

      On attached qvw I got some troubles on the table below :

       

      Please see on the properties of the expression "Inpatient Counter on Item Value =2"

       

      Starting from this expression:

       

      =Count({<[Valor Item]={2},[Id Paciente]=P({<[Orden Form]={">=2"}>}[Id Paciente])>}DISTINCT Aggr(FirstSortedValue([Id Paciente],[Orden Form]),Bloque,Estudio,Centro))

       

      I need a counter of distinct [Id Paciente] on first (or last) [Orden Form] --> FirstSortedValue([Id Paciente],[Orden Form]) where [Valor Item]=2 and for Possible [Id Paciente] with [Orden Form]>=2

       

      My expression doesn't seem to be able to distinguish between first or last [Orden Form] encapsulated on

      Aggr(FirstSortedValue([Id Paciente],[Orden Form]),Bloque,Estudio,Centro)

       

      The result in expresion above should be 0 not 1 becase there is not any [Id Paciente] attached to [Valor Item]={2}

      for selected item ("Otros problemas mentales o conductuales") on first [Orden Form] as you can see on the table below.

       

      Thanks in advance

       

      Lander

       

      Mensaje editado por: Lander Uriarte