Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: date function

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
Contributor III

Re: date function

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
Contributor III

Re: date function

Hi Anil are you from Mathukumalli?

Rgds,

Ajay

Re: date function

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.

Re: date function

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

Regards,
Prashant Sangle

Re: date function

Check enclosed file..

Re: date function

Check enclosed file..

Not applicable

Re: date function

hi ur native place plz?

i am frm vinukonada

& w r u ding?

mail:

gkc9908@gmail.com

Community Browser