Explain min() and max() aggregate functions?
Answer / 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 |
What are the important features of qlikview?
Explain how is data loaded from database?
What is central link table?
What do you understand by QlikView Distribution Service?
Explain how does qlikview storage the data internally?
What is meant by Direct Discovery in QlikView?
What additional date fields can you add using a Master Calendar?
How do you optimize qlikview application?
What are the different components of a dashboard?
What is the use of connect statement?
Explain internal match function()?
What does noconcatenate do?