Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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