Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month selection, help needed

In the front end im pulling month as list box, When i select any month (example May, then all the previous months should also be selected , like Jan to May).

Simillarly it should work for all the months. If i select OCT then JAN to OCT should be selected. How can i get it, Please help me out.

1 Solution

Accepted Solutions
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

I have attached one Application Please check. this solution  will be useful for your problem .

Regards

Perumal A

View solution in original post

9 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

I have attached one Application Please check. this solution  will be useful for your problem .

Regards

Perumal A

Not applicable
Author

Thanks it was perfect.

I need one more thing, if the date is loaded for 2011 and 2010. If you pull Month and year in a multibox and you are selecting year as 2012 then by default month drop down should show only the 2012 calendar months completed or upto the current month,, other months should not be selected.

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Sorry i Can't understand .if possible little brifly  Explain is btter.

Regards

Perumal

Not applicable
Author

We are having a table loaded with 2010 , 2012 , 2011 data. Which will be month and year and amount.

Scenario is the two fields are pulled as a multi box. When i select 2010 year , all the month will be visible simillarly for 2011 all month will be visible. but when i select 2012 year , it should show the month till Jun since it is the current calendar month for 2012. Even if we are having datas for future month of 2012.

For example Amount is a field which is loaded for all the year and its corresponding months.So obviously if i selct year as 2012 , amount data will be shown till dec, since data is loaded till dec 2012. But it should not work like this, when i select year as 2012, data should be shown only till current month.

Final output should be , in the multibox if i selct 2012, month should selected till jan to jun. since jun is current calendar month, In future if the current calendar month is sep means ,then month should be selected from JAN to SEP

Regards,

Gerard

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

I have attached one Application Please check. this solution  will be useful for your problem .

Regards

Perumal A

Not applicable
Author

Hi,

I think you have laoded the date only till jun 2012. But what will happen if there is date till dec 2012 and still if we select year as 2012, the month should be selcted till jun..

Regards,

Gerard

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

I have attached one Application Please check. this solution  will be useful for your problem .

Regards

Perumal A

Not applicable
Author

Hi,

That was perfect thanks a lot. Can you please explain the expression that you have used in the trigger.

Thanks,

Gerard

Not applicable
Author

Hi,

I need a help for the same applicaion but different scenario,

when we open the application it should show current year and the completed month of the year as selected. This should work only for the current year. Next when we change the year as 2010 or 2011 , the month selected should be the current selection of 2012. And later when we change the month , it should show the details for the selected month and year.

If we select any month , it should show only that month detail and not all the previous months, so i have removed the trigger for month selection. I have attached the sample application.