Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date function

HI,

I had a table with hire date(dd-mm-yy hh:mm:ss)

I use Month(hiredate) as Month

the month field contains only jan, feb.oct,nov,dec

but

i want all months in the listbox

see the below image

8 Replies
Not applicable
Author

Hi,

If you use month(hiredate) it will show you only those months which are available in data. Can you please check data in the column hiredate.

please share sample app.

Regards

Shruti

ajaykumar1
Creator III
Creator III

I hope the month function will gives the result based on the field data which you used like Hiredate.

To get all the months you have to pull the month field which you have in the master calender.

Rgds,

Ajay

ajaykumar1
Creator III
Creator III

Hi Anil are you from Mathukumalli?

Rgds,

Ajay

its_anandrjs

The Month field value depends on your hiredate data if there is data only for jan, feb.oct,nov,dec then you not get data for all months. If you need month values like for all months(Jan,Feb,Mar,Apr...Dec) then add master calendar in the data model.

PrashantSangle

Hi,

As Shruti said it is showing you only those months which are available in data which is true.

But if you still want to show all month in ListBox.

Just Create New Inline table

Like

LOAD * INLINE [

    Month

    Jan

    Feb

    Mar

    Apr

    May

    Jun

    Jul

    Aug

    Sep

    Oct

    Nov

    Dec

];

and Use this Month as List box.

Then It will gives you transactions for Those month which is available in your table and Other Value For other show zero or Null

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

Check enclosed file..

MK_QSL
MVP
MVP

Check enclosed file..

Not applicable
Author

hi ur native place plz?

i am frm vinukonada

& w r u ding?

mail:

gkc9908@gmail.com