topic Re: Month filter in QlikView

Month filter

nareshthavidishetty — Fri, 18 Dec 2015 07:45:45 GMT

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

Re: Month filter

MK_QSL — Fri, 18 Dec 2015 07:52:08 GMT

What is the format of your month filter?

Re: Month filter

jagan — Fri, 18 Dec 2015 08:43:33 GMT

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.

Re: Month filter

jagan — Fri, 18 Dec 2015 08:45:21 GMT

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.

Re: Month filter

nareshthavidishetty — Fri, 18 Dec 2015 09:27:51 GMT

Thank you jagan

Re: Month filter

jagan — Fri, 18 Dec 2015 09:34:54 GMT

Hi Naresh,

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

Regards,

Jagan.

Re: Month filter

nareshthavidishetty — Fri, 18 Dec 2015 09:35:25 GMT

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

Re: Month filter

jagan — Fri, 18 Dec 2015 09:37:59 GMT

Hi,

then Enable Hide Excluded option in List Box Properties.

Regards,

jagan.

Re: Month filter

nareshthavidishetty — Fri, 18 Dec 2015 09:50:27 GMT

Hi Jagan,

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

Re: Month filter

jagan — Mon, 21 Dec 2015 00:59:10 GMT

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.