Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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