topic Make a dynamic accumulation in QlikView

Make a dynamic accumulation

Mon, 20 Dec 2010 12:58:10 GMT

Hello

I have a question regarding accumulation. What I am trying to do is to calculate a accumulation based on whatever dates the user chooses for some locations. So if a user chooses the date 2010-03, the accumulation is from a startdate to 2010-03 and showed for all the locations and for all dates inbetween startdate and 2010-03. So the graph would look something like this. The numbers showed are number of sales.

Date

Location 2010-01 2010-02 2010-03

Place A 13 28 50

Place B 16 25 62

Anyone got any clues? I was thinking that set analysis would do the trick by setting the Date dimension to all the previous Date-dimensions, kinda like $<Date={<=Date}> but could not get it to work.

Make a dynamic accumulation

Mon, 20 Dec 2010 14:24:14 GMT

Hello WorkWork,

don't know how your users choose the EndMonth. I assume they select a single value from a Date(EndMonth)Listbox and then your chart(s) shall show a date-range from a given vStartMonth (ie. as a variable, set during load and (or) set via input box) up to the choosen EndMonth. In this case your expression should look like this:

=sum( {<EndMonth = { "$(= ' <=' max(EndMonth) & ' >=' & vStartMonth)" } >} Value)

Note: expr. is not syntax-checked.

Regards, Roland

Make a dynamic accumulation

Mon, 20 Dec 2010 15:31:41 GMT

Thank you! Worked like a charm after some syntax fix.