topic Re: Month and Year Filter in QlikView

Month and Year Filter

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

Guys,

If I select only year or both year and month, the data should be shown only for Year. Is it possible? For Example, I have a field as MonthYear, which has a value like 'Jan 2011'. When I select even 'Jun 2011', the data to be shown only for 'Jan 2011'. Plz help..

Re: Month and Year Filter

surendraj — Mon, 20 Feb 2017 12:09:34 GMT

Yes..you can use set expression in expression tab.

sum({<MonthYear={'Jan 2011'}>}value)

Here i considered dimension as MonthYear,measure as value..

Re: Month and Year Filter

hemanthaanichet — Mon, 20 Feb 2017 12:10:00 GMT

Siva,

you need to hard code it with particular filed values. is this your requirement ??

Can you explain it little elaborate and if possible provid some sample data too

Re: Month and Year Filter

Anonymous — Mon, 20 Feb 2017 12:20:06 GMT

I'm showing KPI values for two widgets in my dashboard. But one widget is showing month wise KPI and the another one showing Year wise KPI. So If load data for both widgets, I'm confused. I'm loading 'MonthYear' format data i.e

Jan-2011 for both the widgets. Plz help...

Re: Month and Year Filter

surendraj — Mon, 20 Feb 2017 12:41:31 GMT

Try with..

Month & '-' & Year as MonthYear

Re: Month and Year Filter

Anonymous — Mon, 20 Feb 2017 12:49:17 GMT

It's also not working....

Re: Month and Year Filter

hemanthaanichet — Mon, 20 Feb 2017 12:54:30 GMT

year(monthyear) as year

month(monthyear) as month

expression

sum({<Year={'2011'},Month={'Jan'}>}value)