topic Re: YTD Button in QlikView

YTD Button

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

rubenmarin — Wed, 04 Apr 2018 14:25:18 GMT

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()))

Nagaraju_KCS — Wed, 04 Apr 2018 14:41:17 GMT

PFA,

Anonymous — Wed, 04 Apr 2018 16:41:20 GMT

Yeah, exactly.

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

Nagaraju_KCS — Wed, 04 Apr 2018 16:56:25 GMT

PFA,

Anonymous — Thu, 05 Apr 2018 11:07:42 GMT

Thanks man!