topic Accumulate values from data, store and article in QlikView

Accumulate values from data, store and article

Mon, 12 Sep 2011 11:54:17 GMT

Hi to all,

I'm a new user of the community and I have a question on accumulate values aggregate by date, store, and article,

if I select only the date the expression works but if I select date and store or date and article or date, store and article the accumulate value doesn’t work …

Can anybody help to understand why it doesn’t work and what can I do to fix the problem

Thanks in advance….

Andrea

Accumulate values from data, store and article

Anonymous — Mon, 12 Sep 2011 12:14:55 GMT

Hi.

In your expression tab, remove the Accumulate 10 steps back option. You have asked QlikView to add up the rows in the table. Your set expression should handle the accumulation over time all by itself.

Cheers.

Ad.

Re: Accumulate values from data, store and article

lironbaram — Mon, 12 Sep 2011 12:17:20 GMT

hei

check this one , you do not need acummolation

Accumulate values from data, store and article

Mon, 12 Sep 2011 12:43:15 GMT

great it works 🙂

many thanks....

Andrea