Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

YTD Button

Hi all,

I have two different dates - AccDate and CrtDate which is aligned to an ClosingCalendar in our project.

We have done lookup and got the month and year for these dates.

I have created one more field called CurrentMonth - which we are looking up to the Closing calendar for today() date.

So I need one button where I need to restrict till the CurrentMonth  .

Is it possible in button like giving Account Month <= CurrentMonth?

Any help is highly appreciated.

Thanks,

Anupama Jagan

1 Reply
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Anupama,

As per my thinking Create button and assign variable  vButton=1

write your expression like :

If(vbutton=1, then  Account Month <= CurrentMonth,


else

Normal conditon,


Thanks,

Arvind Patil