topic Min(Variable) in QlikView

Min(Variable)

Tue, 22 Nov 2011 14:47:10 GMT

I clearly have so much to learn!!!

I have a dataset which contains the field YearPeriod.

This field has records as follows: 2010 01, 2010 02, 2010 03, 2010 04 etc.

If I use YearPeriod as a dimension or expression, I get returns for the above.

However, if I make the expression Min(YearPeriod) I get 201001 - note there is no embedded space - and so this does not match any value in YearPeriod.

Why is this?

How do I return 2010 01?

Muchas Gracias

Dave

Message was edited by: davewright - typo

Min(Variable)

Tue, 22 Nov 2011 15:10:22 GMT

Hi Dave,

There are many ways to address this. I would do something like below:

date#(text(replace(YearPeriod,' ','-')),'YYYY-MM') as YrPeriod

Cheers,

Shyam

Min(Variable)

Tue, 22 Nov 2011 15:31:18 GMT

Hi Shyam,

Thanks for your suggestion, I am most grateful.

However, I'm not sure if it will do what I require.

(Sometimes I'm not sure just how much detail to include when asking.)

The point of Min(YearPeriod) equalling the minimum YearPeriod exactly, is that I want to use it to drive an indexing calculation.

But as there are no data indicated by the YearPeriod 201001 (no space) then I get only errors for the calculation.

If I understand what you have suggested, I will just end up with a Min(YearPeriod) equalling 2010-01, which still won't match any value in YearPeriod, won't I?

I guess I could create a new Year-Period variable by including the "-", but I am reluctant to do so - mainly because I am not comfortable with messing too much with my imported tables.

If you can shed any more light, I would be equally appreciative.

Min(Variable)

Tue, 22 Nov 2011 16:31:24 GMT

Hi Dave,

Method I suggested earlier should work.

Once you create the field, then you could get your minimum and maximum variables using:

let vMin= date(min(YrPeriod),'YYYY MM');

let vMax= date(max(YrPeriod),'YYYY MM');

Cheers,

Shyam

Min(Variable)

Wed, 23 Nov 2011 09:31:50 GMT

Thanks again, Shyam.

Just to be clear, would this be a script command?

Thanks.

Min(Variable)

Wed, 23 Nov 2011 09:46:59 GMT

Hi Dave,

You can have the above in the script.

Another way for adding variables is by clicking on Settings on the toolbar --->Variable Overview and add the variables. Add variable name as vMin and in the expression define this as: =date(min(YrPeriod),'YYYY MM')

Similarly for vMax.

Hope this is suffice.

Cheers,

Shyam

Min(Variable)

Wed, 23 Nov 2011 09:50:24 GMT

Plenty for me to be working with.

Thanks

8-)

Min(Variable)

rohit214 — Wed, 23 Nov 2011 10:32:02 GMT

hI DAve

try this =replace(YearPeriod,'','-')

may it helps you

thanks

rohit