Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Max value for dimension - ignore nulls

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?

3 Replies

Re: Max value for dimension - ignore nulls

You can use the firstsortedvalue for this. See attached qvw.


talk is cheap, supply exceeds demand
jsanchezh
Contributor

Re: Max value for dimension - ignore nulls

This might help you

Not applicable

Re: Max value for dimension - ignore nulls

That worked Gysbert thanks!

What if I want to only show those markets where the date was more than 3 months ago?

Community Browser