topic Label/Expression Mix Max Date in QlikView

Label/Expression Mix Max Date

Sun, 19 Jan 2014 12:02:04 GMT

Hi! I'd like to show in a label the minim and the maxumum of my date fields. The format field is YYYY/MM.

I'm trying to use these functions: MinString and Max String.

But if my range field is from 2010/1 to 2013/11, these functions show me this result from 2010/1 to 2013/9.

There is another function to calculate the correct result from 2010/1 to 2013/11?

Any suggestions greatly appreciated.

Andrea

swuehl — Sun, 19 Jan 2014 12:09:48 GMT

Your dates should be dual values, having a number representation:

Then you can use numeric functions like min() and max(), to create your label and format as needed, something like

=Date(min(DateField),'YYYY-MM') & ' to ' & Date(max(DateField),'YYYY-MM')

Sun, 19 Jan 2014 13:09:01 GMT

Thank you so much for your help!

Could you maybe help me with an example pls?

I'm trying to use this expression with the example attached.

I really appreciate any help you can provide.

swuehl — Sun, 19 Jan 2014 13:50:34 GMT

I think your problem is still that your dates are not correctly parsed in. Have you read Henric's blog post and the pdf linked in his post?

If you parse the dates correctly e.g. using the date#() function, your expression just starts to work. Check attached.

Sun, 19 Jan 2014 23:50:35 GMT

Thank you!