What is the difference between the string aggregate functions MinString(), MaxString() and FirstValue(), LastValue()?
Answer / Amit Pant
MinString() and MaxString() return the minimum and maximum values (in alphabetical order) of a string field, while FirstValue() and LastValue() return the first and last unique non-null value for a field, regardless of their position or sort order.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a pivot table in qlikview?
What do you understand by qvd files?
Which type of load is preferred to load data from previously loaded data?
What is the use of load statement?
What is straight table?
What is set analysis in qlikview?
Which qlikview object has only expression, no dimension?
What is a binary statement in qlikview?
What is Backus-Naur Formalism?
Which graph we will use for two years difference sale?
Based on which factors can qlikview’s use case be categorized?
What operations can you perform using the Tools menu given in the Menu bar?