topic Re: Week function (Current week) in QlikView

Week function (Current week)

Tue, 25 Apr 2017 18:23:00 GMT

Hello everyone,

I'm trying to calculate the current week, but I think that I'm missing something with this code:

Sum({$<Week={MAX(Week(DATE))}>} LOAD_PALLETS)

Someone here can help me with this question?

Thank you!

maxgro — Tue, 25 Apr 2017 19:11:22 GMT

Sum(

{$<Week={"$(=MAX(Week(DATE)))"}>}

LOAD_PALLETS)

Wed, 26 Apr 2017 17:42:20 GMT

Thank you Massimo, that's it.

vishsaggi — Wed, 26 Apr 2017 19:09:45 GMT

Can you close the thread marking correct response.

vishsaggi — Thu, 27 Apr 2017 11:45:09 GMT

Hello Rafael, You marked your reply as Correct. Did Massimo's solution did not work for you? If Yes you should mark his response as correct.

Thu, 27 Apr 2017 13:00:26 GMT

Hello Vishwarath,

I did a mistake, i think that this happened because i'm new here

I think that know is right.

vishsaggi — Thu, 27 Apr 2017 13:01:57 GMT

Sure. No problem, just thought would help you out. 🙂