Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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() 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() 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.
Again, of course...
but you are a genius.
Thanks Stefan!