topic Re: date function in QlikView

date function

Sat, 21 Jun 2014 06:06:40 GMT

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

Re: date function

Sat, 21 Jun 2014 06:30:23 GMT

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

Re: date function

ajaykumar1 — Sat, 21 Jun 2014 06:31:06 GMT

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

Re: date function

ajaykumar1 — Sat, 21 Jun 2014 06:38:21 GMT

Hi Anil are you from Mathukumalli?

Rgds,

Ajay

Re: date function

its_anandrjs — Sat, 21 Jun 2014 07:02:32 GMT

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

PrashantSangle — Sat, 21 Jun 2014 07:08:16 GMT

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

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,

Re: date function

MK_QSL — Sat, 21 Jun 2014 08:32:48 GMT

Check enclosed file..

Re: date function

MK_QSL — Sat, 21 Jun 2014 08:32:53 GMT

Check enclosed file..

Re: date function

Mon, 23 Jun 2014 14:20:53 GMT

hi ur native place plz?

i am frm vinukonada

& w r u ding?

mail:

gkc9908@gmail.com