select possible values inweek inmonth

[#1]

Hello,

I'm working on my first application on Qlikview and I'd like user be able to qlik on buttons This Day, This week and This Month.

I added 3 buttons.

The first one, this day trigger the action "Select possible values" and then I added the name of the field I'm filtering (taux_date) and it's looking for =max(taux_date)

Works perfectly.

But for the 2 others, I've tried several stuff like "=Inweek(taux_date,MaxDate_taux,0)" where "MaxDate_taux" is my max value, or =Inweek(taux_date,max(taux_date),0) but nothing works.

I'm pretty sure once I'm making it work for weeks it'll be the same for the month but I'm stuck.

How can I do ?

Regards,

T.

[#2]

Hello,

You can put an example of the application?

By

Rebeca

[#3]

Probably you need to pass the current Date insted of  MaxDate_taux

[#4 · Accepted solution]

Actually it was a lot easier thn I thought !

I wrote :

=week(max(taux_date)) !

Thanks anyway