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 |
Explain mini chart?.what do you mean by sub reports and how we can create them?
Define trellis chart?
What are the four types of bookmarks in QlikView?
What is a Master Calendar?
What do you understand by extended interval match function()?
What is circular reference/loops?
What does partial reload do?
What causes Circular References?
What is a direct query?
What are the types of wizards that are found in Tools menu?
How can we see the table structures of data loaded to qlikview’s memory?
What are the different components of a dashboard?