topic Re: Show Week Ending Date in QlikView

Show Week Ending Date

Mon, 08 Sep 2014 20:35:10 GMT

Hi all,

I am currently trying to have a chart title show the week ending date whenever a Financial Week is selected. With the data I have, I have to do this by selecting the highest day (DAY_DT) of the selected week (FINANCIAL_WEEK). The code I have written so far is:

If(GetSelectedCount(FINANCIAL_WEEK) >= 1, 'Wk Ending ' & ...

And this is where I am stuck. I have tried combinations with FirstSortedValue but nothing seems to work, and it just returns "Wk Ending " when a week is selected. Any suggestions?

Re: Show Week Ending Date

JonnyPoole — Mon, 08 Sep 2014 20:41:41 GMT

Is DAY_DT a date field or numerical field ? Please share the data format. If its a date this may work:

If(GetSelectedCount(FINANCIAL_WEEK) >= 1, 'Wk Ending ' & max(date(DAY_DT)) )

Otherwise please share the data format of the values as they appear in a list box.

Re: Show Week Ending Date

Mon, 08 Sep 2014 20:42:22 GMT

You can use Weekend() function which gives you Sunday. If you want Friday as the weekend date then you can use "date(weekend(today())-2)". Hope this helps.

Thanks

Re: Show Week Ending Date

Mon, 08 Sep 2014 20:43:14 GMT

instead of 'Wk Ending ' try Max(Day_DT)

Thanks

Suraj

Re: Show Week Ending Date

Mon, 08 Sep 2014 20:45:18 GMT

This worked perfectly. I think I was trying to get too complicated. Thanks for the quick response!