topic Min() in QlikView

Min()

Thu, 24 Nov 2011 14:33:24 GMT

Right... I am making some progress, chipping away at the QV logic.

But something simple is causing me stress, and making it difficult to take the next step.

It's something I've hinted at already, but I need a simple answer, so I'm going to make the question as simple as possible, so I don't get confused by your help!

I have loaded table data as follows:

YearPeriod

2010 01

2010 02

2010 03

2010 04

etc...

If I apply the function Min(YearPeriod)

I get:

201001

not:

2010 01

(Aaaaarrrggghhh!!!)

Why?

And more importantly, what should I use instead?

I thank you.

Dave

Min()

swuehl — Thu, 24 Nov 2011 14:38:20 GMT

Min() function will return a numeric value, so 201001 is ok (for some reason, QV can interpret string value 2010 01 as 201001 numerical value).

You could use minstring(YearPeriod) to get what you want.

Min()

Thu, 24 Nov 2011 14:41:32 GMT

Again, of course...

but you are a genius.

Thanks Stefan!