Discussion Board for collaboration on QlikView Scripting.
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
i want all months in the listbox
see the below image
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.
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.
Hi Anil are you from Mathukumalli?
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.
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 [
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
Check enclosed file..
hi ur native place plz?
i am frm vinukonada
& w r u ding?