topic Re: Month Expression in QlikView

Month Expression

Tue, 04 Feb 2014 07:51:11 GMT

Hi All,

I have a text object named as view current month. I have added in the actions tab -

1. Clear all

2. Select in field - Month(Today).

But when i click on the text object view current month. Indeed it shows the current month on the top but also it shows all the data - including previous months and years.

My requirement is when i click on the view current month, it should display only that month.

For example if iam in January month - It should show only january data.

Currently it shows Jan ,2014 on the top until back to 2008 data.

Thanks for the help here.

Ben

Re: Month Expression

MK_QSL — Tue, 04 Feb 2014 07:59:42 GMT

Write in text box

Only(Month)

Re: Month Expression

Tue, 04 Feb 2014 08:15:21 GMT

PFA,

Hope this will help you

Re: Month Expression

Tue, 04 Feb 2014 08:32:19 GMT

Change your second action to

Select in Field - Month(Today()).

Re: Month Expression

Tue, 04 Feb 2014 09:37:38 GMT

Hello All,

Month(Today()) works. But the problem is it shows data for Feb -2014, Feb -2013, Feb .2012 .....etc

It is not just showing Feb 2014 Data.

So I added another select in field with Year (Today()). Now it show for 2014 data including january.

Any other solution

Thanks

Ben

Re: Month Expression

Tue, 04 Feb 2014 09:44:58 GMT

Panicker see my previous attached file it will help this

Re: Month Expression

MayilVahanan — Tue, 04 Feb 2014 09:45:07 GMT

Do you have monthyear field?

if so, try with that.

Year -> Max(Year) or Year(Max(DateField))

Month -> Month(Today()) or Month(Max(DateField))

hope it helps

Re: Month Expression

Tue, 04 Feb 2014 11:19:21 GMT

Hi All,

It works now.

Solution:

Select in field - Month(Today())

Select in field - Year(Today())

Here in the field I have taken the appropriate field name.

My issue was i have 20 tabs and this object was linked. but the month field names were different.

I have input the correct field names accordingly in each sheet and unlinked the same. so its working.

Another workaround i guess is in the script i need to make it unique for all the months and year.

Thanks

Ben