topic Re: Set analysis / aggr - Get value over 2 dimension in QlikView

Set analysis / aggr - Get value over 2 dimension

daniel1990xyz — Wed, 16 Sep 2015 12:22:14 GMT

Hello everyone,

I need some help regarding the following problem:

I have a chart with the Dimension "PatientID" and I want to show as an expression for each Patient the oldest "Hb" value (marked values in the screenshot). As shown in the screenshot a patient can have different parameter values for a date. The relevant parameter (in this example "Hb") is stored in the variable "Para4PatOverview".

I have tried to implement this requirement with aggr and set analysis but I can't solve completely the problem.

The following code works, but only when one entry for the oldest date for a patient is stored in the dataset (green marked example).

=min(aggr(if(DiagramDate =

Min({<DiagramPar={$(Para4PatOverview)}>} DiagramDate), DiagramValue),DiagramDate))

When more than one entry is available for the oldest date for the patient (red marked examples) the code returns nothing.

I am grateful for any help.

Best regards,

Daniel

Re: Set analysis / aggr - Get value over 2 dimension

sasiparupudi1 — Wed, 16 Sep 2015 12:32:15 GMT

may be try

=min(aggr(if(DiagramDate=Min({<DiagramPar={$(Para4PatOverview)}>} DiagramDate), DiagramValue),DiagramDate,PatientID))

Re: Set analysis / aggr - Get value over 2 dimension

sunny_talwar — Wed, 16 Sep 2015 12:36:09 GMT

Can you give this a shot may be:

=FirstSortedValue(DISTINCT {<DiagramPar = {'Hb'}>} DiagramValue, -DiagramDate)

Re: Set analysis / aggr - Get value over 2 dimension

lironbaram — Wed, 16 Sep 2015 12:57:24 GMT

you can use this expression

=if(DiagramDate =min(total <PatientID> {<DiagramPar={hb}>}aggr(min({<DiagramPar={hb}>}DiagramDate ),PatientID)),red())

Re: Set analysis / aggr - Get value over 2 dimension

daniel1990xyz — Wed, 16 Sep 2015 14:09:23 GMT

Thank you, this solves my problem.