Discussion Board for collaboration related to Creating Analytics for QlikView.
Distinct function doesnt' work with max function in QlikView 10 SR 3
LOADMAX(DISTINCT AgreementID) as AgreementIDResident Master;
MAX(DISTINCT AgreementID) as AgreementID
This dosen't Work. It works fine in 8.5.
Any idea to solve this ?
just a question
why do you need the distinct the result will be the same with out it