Interested to Buy Any Domain ? << Click Here >> for more details...
Explain min() and max() aggregate functions?
- 1 Answers
- 3 Views
- I also Faced
- E-Mail Answers
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 |
How can we see the table structures of data loaded to qlikview’s memory?
What is relative path?
What is keep?
What is star sechma ?
What are Modifiers in Set Analysis?
What is apply map (mapping tables)?
What does *bi* in text search mean?
What is straight table?
Explain binary load?
Explain qlikview’s architecture in brief?
Which protocols are used in sending commands in QlikView?
How can we get the number of statements which have caused errors during a script execution?
QlikView 
