topic select possible values inweek inmonth in QlikView

select possible values inweek inmonth

Mon, 18 Mar 2013 13:21:09 GMT

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,

Re: select possible values inweek inmonth

Mon, 18 Mar 2013 13:26:34 GMT

Hello,

You can put an example of the application?

Rebeca

Re: select possible values inweek inmonth

Mon, 18 Mar 2013 13:41:08 GMT

Probably you need to pass the current Date insted of MaxDate_taux

Re: select possible values inweek inmonth

Mon, 18 Mar 2013 14:01:19 GMT

Actually it was a lot easier thn I thought !

I wrote :

=week(max(taux_date)) !

Thanks anyway