Answer Posted / Kapil Deol
The "min()" and "max()" aggregate functions in QlikView return the minimum and maximum values, respectively, for a specified set of data. They can be applied to numeric or date fields.nnFor example, to find the minimum sales amount across all customers, you could write the following expression:nnmin(SalesAmount) by CustomerIDnnSimilarly, to find the maximum sales amount for each product category, you would use:nnmax(SalesAmount) by ProductCategory
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers