Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Display current month Data

Hi,

I have the data of the year. I want to display only the current month's data. 

I have 2 rows: Date(like this-10/1/2017) and HourRange(0-1, 1-2 etc)

What expression should I write to show only  the current month's data?

Capture.PNG

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

in expression

Avg({<YearMonthField={"$(=Date(Today(), 'YYYYMM'))"}>}  YourField)

View solution in original post

1 Reply
Highlighted
Creator III
Creator III

in expression

Avg({<YearMonthField={"$(=Date(Today(), 'YYYYMM'))"}>}  YourField)

View solution in original post