# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Contributor

## Set analysis: forecst where YearMonth > year(today())&month(today())

Hi,

New to qlikview,

I have a field named YearMonth. It's set up so that months jan - sep have a zero before their number, so we have e.g. 202109, 202110...

I've been working on a dynamic expression that would return consumption forecast data where YearMonth is larger than the year&month of today's date.

For example, this one returns data for months 5-12 for all year in scope:

=Sum({<Month={'>\$(=Num(Month(Today())))'},>}kWh)/Volume

This one returns data for all months and all years in scope:

=Sum({<Month={'>\$(=Month(Today()))'},>}kWh)/Volume

Not sure why. My understanding is that stuff quoted with single quote signs allows us to use QV built-in functions, i.e. the below is not doable since the platform does not include a YearMonth function?

=Sum({<YearMonth={'>\$(YearMonth(Today(),"YYYYMMDD"))'},>}kWh)/Volume

I guess set expression modelling fundamentally differs, but borrowing some excel syntax, I'm looking for:

=Sum({<YearMonth={'>\$(=Year(Today())&IF(Len(Month(Today()))=1;”0”&Month(Today());Month(today())))'},>}kWh)/Volume

Cheers,

Robin

1 Solution

Accepted Solutions
Specialist II

Try Sum({<YearMonth={">\$(=Date (Today (1),'YYYYMM'))"}>}kWh)/Volume

The Date(Today(1),'YYYYMM") should return YearMonth like 202110

2 Replies
Specialist II

Try Sum({<YearMonth={">\$(=Date (Today (1),'YYYYMM'))"}>}kWh)/Volume

The Date(Today(1),'YYYYMM") should return YearMonth like 202110

Contributor
Author

Thanks, did the trick!