Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
filippo_cardoso
Contributor III
Contributor III

YTD Button

Hello folks,

I'd like to creat a button in QV that selects all months that already passed

(for example: we are in April, I need to select Jan, Feb and Mar)

Month is the field name.

Could you people help me?

Thanks in advance

Filippo

1 Solution

Accepted Solutions
qv_testing
Specialist II
Specialist II

5 Replies
rubenmarin

Hi Filippo, it can vary depending how the month field is created, but this can work in some situations:

In properties of the button add an action "Select in field":

FieldName: MonthFieldName

Value: ='<=' & Num(Month(Today()))

qv_testing
Specialist II
Specialist II

PFA,

filippo_cardoso
Contributor III
Contributor III
Author

Yeah, exactly.

But, I want to click YTD and select from 01/jan to 31/mar, because April has not finished yet.

qv_testing
Specialist II
Specialist II

PFA,

filippo_cardoso
Contributor III
Contributor III
Author

Thanks man!