topic Re: Aggregate value for 7 days after date selected in QlikView

Aggregate value for 7 days after date selected

Anonymous — Mon, 27 Jun 2016 11:26:52 GMT

Hi guys,

I have information about about nº of downloads by date. On my Dashboard i have a table with DATE and Nº OF DOWNLOADS, and i have a filter DATE too.

My question is. It is possible create a expression too wen i select some date, my output be the aggregation from Nº OF DOWNLOADS 7 days starting DATE selected.

Exemple:

I select date '2016-06-05' and the output is

sum( {<DATE={'2016-06-05'+'2016-06-06'+.........+'2016-06-07'}>} Nº OF DOWNLOADS)

Thanks in advance,

Pedro Lopes

Re: Aggregate value for 7 days after date selected

settu_periasamy — Tue, 28 Jun 2016 02:22:16 GMT

May be try

=sum( {<DATE={'>=$(=DATE)<=$(=Date(DATE+7))'}>} [Nº OF DOWNLOADS])

Re: Aggregate value for 7 days after date selected

sunny_talwar — Tue, 28 Jun 2016 02:59:12 GMT

Not sure how the environmental variables are set, I would just suggest one change:

=Sum({<DATE={'>=$(=Date(Max(DATE), 'YYYY-MM-DD'))<=$(=Date(Max(DATE)+7, 'YYYY-MM-DD'))'}>} [Nº OF DOWNLOADS])

Re: Aggregate value for 7 days after date selected

Anonymous — Wed, 29 Jun 2016 14:41:30 GMT

This expression only give me the value from selected day.

Re: Aggregate value for 7 days after date selected

sunny_talwar — Wed, 29 Jun 2016 14:56:03 GMT

Are you making selection in DATE field? or is there another field you are making selection in?

Re: Aggregate value for 7 days after date selected

Anonymous — Wed, 06 Jul 2016 08:24:45 GMT

Yes, i only have a data field to make selection.

Example:

A DATA filter and a table with DATA, NAME of PRODUCT and N OF DOWNLOADS.

Re: Aggregate value for 7 days after date selected

Anonymous — Wed, 06 Jul 2016 08:25:49 GMT

Sorry DATA means DATE