Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Week function (Current week)

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Week function (Current week)

Sum(

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

LOAD_PALLETS)

6 Replies
MVP
MVP

Re: Week function (Current week)

Sum(

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

LOAD_PALLETS)

Not applicable

Re: Week function (Current week)

Thank you Massimo, that's it.

vishsaggi
Esteemed Contributor III

Re: Week function (Current week)

Can you close the thread marking correct response.

vishsaggi
Esteemed Contributor III

Re: Week function (Current week)

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.

Not applicable

Re: Week function (Current week)

Hello Vishwarath,

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

I think that know is right.

vishsaggi
Esteemed Contributor III

Re: Week function (Current week)

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