topic Re: WTD in QlikView

WTD

Tue, 27 May 2014 04:23:18 GMT

Hi,

I want to show up the values in Week to date eg., sum of sales till week to date.

Can some one help me with the formaulae.

Many Thanks,

Swathi

Tue, 27 May 2014 05:14:37 GMT

Him

try this

week(date field)

ferha_jafri — Tue, 27 May 2014 05:33:43 GMT

Try this :

sum({<Year={'$(=max(Year))'},Month={'$(=Max(Month))'},Week={'$(=Max(Week))'},Date={'<=$(Max(Date)))'}>}Sales)

this will give you WTD

Tue, 27 May 2014 05:46:46 GMT

But Max of week is giving last week ie., 52nd week, which is not the WTD right?

is it Week={'$(=week(today()))'}?

Correct me if i'm wrong.

Thanks,

Swathi

CELAMBARASAN — Tue, 27 May 2014 05:47:37 GMT

Hope it helps

ferha_jafri — Tue, 27 May 2014 06:22:31 GMT

No , it will give you max month max week , i.e the month you select.