Discussion Board for collaboration on QlikView Scripting.
How can i find what the maximum date for a certain dimension is in the attached data is, ignoring nulls.
i.e. i need to know the most recent date for each market when there was revenue
Is it possible to do this in chart rather than in the load?
You can use the firstsortedvalue for this. See attached qvw.
This might help you
That worked Gysbert thanks!
What if I want to only show those markets where the date was more than 3 months ago?