only() with aggr

hopkinsc — Fri, 05 Nov 2021 17:18:17 GMT

Hi all,

I am trying to use the only() function along with aggr() and set analysis, but struggling to get it working.

I have some factory data along with audit dates and the company name that performed the audit.

I am trying to get the previous audit company name.

I have attached an example QVW with some very basic sample data.

Basically, the previous audit has the max 'CompletionDate', so its the 'CompanyName' that i want to get thats related to the max(CompletedDate), but its being displayed in a straight table, and the only() function is only returning the result for the max(CompletedDate) for the whole dataset, i need it to work row by row. It does work as expected when selections are made on the FactoryName.

This is the required output..

FactoryName	Date	CompanyName
Factory1	08/06/2018	CompanyA
Factory2	27/12/2020	CompanyC

It could be that ONLY() is not the correct function to use.

Any help would be appreciated.

Re: only() with aggr

maxgro — Sun, 07 Nov 2021 11:31:03 GMT

If I understand the question,

try with FirstSortedValue(PreviousCompany, -Date)

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/BasicAggregationFunctions/firstsortedvalue.htm

topic only() with aggr in QlikView

only() with aggr

Re: only() with aggr