topic Re: select month name based on selected date in QlikView

select month name based on selected date

Fri, 30 Aug 2013 12:37:41 GMT

Hi,

I have three list box Year,Day(1,2,3..) and monthNam(Jan,Feb,Mar..) and 2 calendar object.

Based on the selected start date and end date in the two calendar objects i need to auto select year, days and MonthName in the 3 list boxes.

Year and Day i am able to select by using Search String action on respective fields when start date and end date are selected,

But same logic when i apply on Monthname it does not work. Below are the search strings i tried to auto select month but doesn't work

='=' & Month(vFromDate) & '=' & Month(vTodate)

='>=' & Month(vFromDate) & '<=' & Month(vTodate)

Can someone helpout on this

Re: select month name based on selected date

Fri, 30 Aug 2013 12:48:32 GMT

Hi,

Can you please post your sample file

Re: Re: select month name based on selected date

Fri, 30 Aug 2013 13:25:25 GMT

Hi,

I have attached sample.qvw. In this when you select any start date and end date in calendar object, the year and day listbox auto select based on calendar dates.

I have done this by adding trigger on variables vstartdate and venddate which are used in calendar object.

But when same logic i apply on MonthName it fails

Re: select month name based on selected date

tresB — Fri, 30 Aug 2013 13:41:01 GMT

Try something like:

='(>=' & Month(vFromDate) & '| <=' & Month(vTodate)&')'

Re: select month name based on selected date

abeyphilip — Fri, 30 Aug 2013 13:42:46 GMT

Hi,

See the expression for Month and Day list boxes.

Regards,

Abey

Re: Re: select month name based on selected date

Fri, 30 Aug 2013 13:46:17 GMT

Thanks for the reply, but it still doesn't work

Re: select month name based on selected date

MayilVahanan — Fri, 30 Aug 2013 13:56:04 GMT

Try like this

Instead of selectedField option, try select possible in both variable trigger

Select Possible -> MonthName

Hope tat helps

Re: Re: select month name based on selected date

Fri, 30 Aug 2013 13:56:26 GMT

i didn't got you Abey. As in list box i am directly using field. So the expression will be empty. Moreover day part is working , i am facing issue only in month.

Re: select month name based on selected date

Anonymous — Fri, 30 Aug 2013 13:56:46 GMT

To create a variable

vstartdate=makedate(year(venddate),01,01)

venddate

vpstartdate=addyears(vstartdate,-1)

vpenddate=addyear(venddate,-1)

Re: Re: select month name based on selected date

Fri, 30 Aug 2013 13:59:48 GMT

Thanks a lot, select possible solves my issue.

Re: select month name based on selected date

MayilVahanan — Fri, 30 Aug 2013 14:01:24 GMT

HI Avi Chawla

Please close the post.