topic Re: Select Week From current date in QlikView

Select Week From current date

Fri, 21 Aug 2015 09:17:59 GMT

Hi,

i have a question, i have a calendar data contain Date and Week,

For example

Date Week

01/12/2015 1

01/24/2015 3

Assume today's date is 01/24/2015. So i want to show '3' for the week.

i use this expression, but it doesnt work

=only({<Date={=date(Today(),'MM/dd/yyyy')}>}Week)

really appreciate your help, thanks

Fri, 21 Aug 2015 09:25:54 GMT

Why don't you try

Week(Today()) as Your expression

sunny_talwar — Fri, 21 Aug 2015 09:32:00 GMT

May be this:

=Only({<Date={"$(=Date(Today(),'MM/DD/YYYY'))"}>}Week)

sasiparupudi1 — Fri, 21 Aug 2015 09:37:23 GMT

try

week(Date#(YourDate,'MM/DD/YYYY'))

Fri, 21 Aug 2015 10:00:02 GMT

Wow thanks guys, all of you are true problem solver

thanks

sasiparupudi1 — Fri, 21 Aug 2015 10:02:24 GMT

You are welcome, glad that you could get the answer you were looking for..

Sas