How to get all months list >= current month

[#1]

Hi All,

I want to display months in a list box.Month names should be greater than and equal to current month.

Ex: current month=mar

so i want mar,apr,may,june,...dec

Thank you

Regards,

Prajna

[sunilkumarqv]

Hi Prajna

Go list box end make an experssion below so you get all month which greter than are equal to mar .

=if(Month>='Mar',Month)

Hope you get the solution

[sunilkumarqv]

Try this

see attached

[tresesco]

Assuming that you have a field MonthField created in the script using monht() function, you can try the list box expression like:

=If(MonthField>=Month(Today()), MonthField)

[MK_QSL]

How's your Month dimension is formatted?

[jsingh71]

Hi Prajana,

You need to put expression in list box. Find attachment for your reference.

[#7]

hi,

I haad already tried this..but problem i faced is em not getting months whocse letter is less than m

like apr,dec...

Can u tell me what the prob?

I have a date field from there i have got month field using datename function...is it coz of thuis method?

what can i use to get monthnames from date field?

Thank you

Reagrds,

Prajna

[#8]

Hi,

select left(datename(mm,"START_DATE"),3)as 'Production month'  from tablename

I have rerreived in this fashion.

Thank you

ReGARDS,

pRAJNA

[sunilkumarqv]

Because you driven month from Date in you data .but actually Month which defind in If condition it not considering your data its refering qlikview month

So see attached

Try to change Month you you can create ID

=if(ID>= Num(MonthData(Now())),MonthData)

[tresesco · Accepted solution]

Then try like:

=If( Month(Date#(MonthField, 'MMM'))>=Month(Today()), MonthField)