Month filter

[nareshthavidishetty]

Hi currently i have month filter like 2015 January to 2015 December but i need to show month filter from February 2015 to January 2016.

Can any help me how to do this 

[MK_QSL]

What is the format of your month filter?

[jagan]

Hi Naresh,

Can you attach some sample data and your expected result so that it would be easier for us to provide solution.  Please check below link it helps you in getting answers more faster.

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

jagan.

[jagan]

Hi,

If you want to Convert Jan-2015 to Feb-2015, just add one month to the date, like below

LOAD

*,

MonthName(AddMonths(DateFieldName, 1)) aS Month

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[nareshthavidishetty]

Thank you jagan

[jagan]

Hi Naresh,

If you got the answer please close this thread by giving Correct Answer to the useful thread.

Regards,

Jagan.

[nareshthavidishetty]

Jagan my dashboard consists Year and month selection in a list box like below

If i click on Year 2015 corresponding months which have data only to displayed like below image

Can you please help me on this

[jagan]

Hi,

then Enable Hide Excluded option in List Box Properties.

Regards,

jagan.

[nareshthavidishetty]

Hi Jagan,

If i have all months data but in need to show particularly two moths like below(Default filter like below)

[jagan]

Hi,

I am not sure what you are trying to do?  Can you explain a bit with some example and sample file?  When you want to show all values, when you don't want to show all values?

Regards,

Jagan.