topic Month Selection in QlikView

Month Selection

rajkumarb — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

my current max date is 17-aug-2017

if i dont make any selection in month field, then it should default to last full completed month
in my case that is june 2017
else if i make a selection in the month field means then it should be the selected month

below is the if condition I am using but its not working

please suggest.

=IF(len(GetFieldSelections([Calendar Month]) )=0, MONTHEND(AddMonths(today(-1), -1)),[Calendar Month])

Re: Month Selection

Anonymous — Thu, 06 Jul 2017 10:20:38 GMT

Hi Raj,

Can you clearly explain your requirement. Pls!!

Thanks

Harshitha

Re: Month Selection

kaushiknsolanki — Thu, 06 Jul 2017 10:23:47 GMT

Hi,

Try this.

IF(GetFieldSelections([Calendar Month])=0, MONTHEND(AddMonths(Max([Calendar Month]), -1)),Max([Calendar Month]))

Regards,

Kaushik Solanki

Re: Month Selection

rajkumarb — Thu, 06 Jul 2017 10:50:27 GMT

Hi Kaushik

its not working as expected

Re: Month Selection

kaushiknsolanki — Thu, 06 Jul 2017 10:51:31 GMT

Kindly share your application.

Regards,

Kaushik Solanki

Re: Month Selection

sunny_talwar — Thu, 06 Jul 2017 11:17:42 GMT

What exactly is your goal here? Make a month selection or just save the value in a variable? Would you be able to elaborate a little?

Re: Month Selection

rajkumarb — Thu, 06 Jul 2017 11:40:40 GMT

Hi sunny

I want to store this in a variable

=IF(len(GetFieldSelections([Calendar Month]) )=0, MONTHEND(AddMonths(today(-1), -1)),[Calendar Month])

my requirement is

my max date in my app is 17-aug-2017

in my text box with my variable want to see a month, if no selections were made on month list box, then it should show last fully completed month(which is June 2017) in my text box, else selected month need to shown

Re: Month Selection

sunny_talwar — Thu, 06 Jul 2017 11:43:06 GMT

May be this

Date(If(GetSelectedCount([Calendar Month]) = 0, (MonthStart(Today()) - 1), Max([Calendar Month])))

Re: Month Selection

rajkumarb — Thu, 06 Jul 2017 11:56:12 GMT

sunny

When I use this in the text box and select June

its displaying

05/01/1900

Re: Month Selection

sunny_talwar — Thu, 06 Jul 2017 11:59:30 GMT

Can you show an image of a list box for Calendar Month?

Re: Month Selection

rajkumarb — Thu, 06 Jul 2017 12:18:03 GMT

Re: Month Selection

sunny_talwar — Thu, 06 Jul 2017 12:20:53 GMT

Is Jan, Feb, Mar.... your calendar Month field? What is the date field my friend? Did you expect Jun to convert to a date by itself? Use this

Date(If(GetSelectedCount([Calendar Month]) = 0, (MonthStart(Today()) - 1), Max(DateFieldHere)))