topic Re: current week's date in QlikView

current week's date

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have a date field called 'ORDEREDDATE'.

In my pivot table, i want to display current week's dates alone.

i tried the dimension as date(week(max(ORDEREDDATE))). but i m getting error.

can someone help me to correct the expression please..

sunny_talwar — Wed, 08 Jun 2016 13:27:13 GMT

How about this:

If(ORDEREDDATE >= WeekStart(Today()), ORDEREDDATE)

and select 'Suppress When Value Is Null'

sunny_talwar — Wed, 08 Jun 2016 13:28:27 GMT

Alternatively you can use Set Analysis as well

{<ORDEREDDATE = {"$(='<=' & Date(WeekStart(Today()), 'DateFieldFormatHere'))"}>}

Assuming you don't have dates in the future.

Wed, 08 Jun 2016 13:38:42 GMT

Hi Sunny,

Instead of Weekstart(Today()), how can i do this for Max(ORDEREDDATE)

sunny_talwar — Wed, 08 Jun 2016 13:40:19 GMT

May be this:

If(ORDEREDDATE >= Max(TOTAL ORDEREDDATE) - 7, ORDEREDDATE)

trdandamudi — Wed, 08 Jun 2016 13:45:44 GMT

May be this: (I modified Sunny's expressions):

If(ORDEREDDATE >= Max(ORDEREDDATE))

Or in Set analysis:

{<ORDEREDDATE = {"$(=Max(ORDEREDDATE))"}>}