Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Month Year in Expression

I want to show only a specifc Month year in an expression based on todays date.  So if today date is 03/07/2013, I want the expression to show on Mar 2013 data.  Below works

Sum({<CalendarWrittenYear = {2013}>} Subtotal)

But I need something like

Sum({<CalendarMonthandYear= {Today}>} Subtotal)

So the CalendatMonthandYear is Mar 2013, I need to convert today into Mar 2013.

Help!!!





5 Replies
jagan
Not applicable

Re: Month Year in Expression

Hi,

Try this

=Sum({<CalendatMonthandYear={"=$(=Month(Today()) & ' '&Year(Today())"} >} Subtotal)

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Month Year in Expression

Does not want to work, the expression says it is OK, but I get no data.

Lance H. James, CPA

Director of Finance

The Aspen Brands Company

Kate Aspen · Baby Aspen

678.282.0053 x 777

<http://www.theaspenbrands.com/>

<http://www.kateaspen.com/>

<http://www.babyaspen.com/>

Not applicable

Re: Month Year in Expression

How is the field CalendarMonthandYear formatted in your data? I guess it can be a little different that jagan mohan assumed (e.g. 'March 2013')

Not applicable

Re: Month Year in Expression

I am usind the calendar app to help with the dates, the dates are first 3 letter of the month, followed by space then year.  So 03/04/2014 would be "Mar 2013"

kaushik_solanki
Not applicable

Re: Month Year in Expression

Try to create MonthYear as follows.

Monthname(Date) as CalendarMonthandYear

Then you can use below expression in chart to get the desired result.

Sum({<CalendarMonthandYear= {"$(=monthname(Today()))"}>} Subtotal)

Regards,

Kaushik Solanki