topic Re: Set Analysis Rolling Period in QlikView

Set Analysis Rolling Period

Mon, 12 Oct 2015 06:30:07 GMT

Hi Experts,

I have created a dashboard. My requirement is want to show Last 15 Days Sales.

My expression is like this:

Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=DayStart(Max(TransactionDate), -14))<=$(=Max(TransactionDate))'}>} Sales )

But am getting overall 31 Days. Please help me how to achieve this

Thanks in Advance

Re: Set Analysis Rolling Period

gautik92 — Mon, 12 Oct 2015 06:31:26 GMT

have a look at this

Set Analysis for Rolling Periods

Re: Set Analysis Rolling Period

SreeniJD — Mon, 12 Oct 2015 06:37:49 GMT

Try this -

Last 15 Days Sales

Sum({<Year=, Quarter=, Month=, Week=, TransactionDate={‘>=$(=Date(Max(TransactionDate)-14))<=$(=Date(Max(TransactionDate)))’}>} Sales )

HTH

Sreeni

Re: Set Analysis Rolling Period

Mon, 12 Oct 2015 06:58:08 GMT

Its not working

Re: Set Analysis Rolling Period

avinashelite — Mon, 12 Oct 2015 06:59:49 GMT

can you please share the app and sample data

Re: Set Analysis Rolling Period

SreeniJD — Mon, 12 Oct 2015 07:00:18 GMT

Hey Abhi

Is your date in proper format.. if not use Date# function to covert into required date format.

or else attach a sample application, which will help us to provide quick solution for you

Sreeni

Re: Set Analysis Rolling Period

ecolomer — Mon, 12 Oct 2015 07:06:29 GMT

Try without week=

Sum({<Year=, Quarter=, Month=, TransactionDate={'>=$(=DayStart(Max(TransactionDate), -14))<=$(=Max(TransactionDate))'}>} Sales )

Re: Set Analysis Rolling Period

Mon, 12 Oct 2015 07:14:01 GMT

Hi,

Please find attached Sample application.

Thank You, !

Re: Set Analysis Rolling Period

tresB — Mon, 12 Oct 2015 07:23:44 GMT

Try:

Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=Date(Max(TransactionDate) -14))<=$(=Date(Max(TransactionDate)))'}>} Sales )

If you don't see, last 15 days data here, that is because you don't have data for those dates.

Re: Set Analysis Rolling Period

Anonymous — Mon, 12 Oct 2015 07:38:23 GMT

Hi,

If you don't have data for last 15 days obviously you don't see any data. First check your data whether you have transactions on those days or else below expression works.

Try this:

Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=Date(Max(TransactionDate) -14))<=$(=Date(Max(TransactionDate)))'}>} Sales )

Hope it helps!!

Re: Set Analysis Rolling Period

Mon, 12 Oct 2015 08:02:07 GMT

Thank You Every One!!

Re: Set Analysis Rolling Period

Mon, 12 Oct 2015 08:04:17 GMT

Thank You Tresesco & Anil,

Yes, I don't have transactions on that days. Thank you for your support

Re: Set Analysis Rolling Period

Anonymous — Mon, 12 Oct 2015 08:07:20 GMT

Glad to Help you