Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

Hi,

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

Regards

Perumal A

View solution in original post

Highlighted
Not applicable

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.

Highlighted
Partner
Partner

Hi,

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

Regards

Perumal

Highlighted
Not applicable

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

Highlighted
Partner
Partner

Hi,

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

Regards

Perumal A

Highlighted
Not applicable

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

Highlighted
Partner
Partner

Hi,

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

Regards

Perumal A

Highlighted
Not applicable

Hi,

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

Thanks,

Gerard

Highlighted
Not applicable

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.