topic Re: Set Analysis for Line Chart that shows 2 previous before selection and 2 after selection in line chart in QlikView

Set Analysis for Line Chart that shows 2 previous before selection and 2 after selection in line chart

Fri, 02 Dec 2011 22:00:47 GMT

I would like to create a line chart and when I select on the volume list box I would like the line chart to show the previous two sales amounts before the selection, the selected value and the two sales amounts after the selection. (A 2 prior / 2 post selection rolling report).

Just can figure out the set analysis of how to include the selection -2 and +2.

Re: Set Analysis for Line Chart that shows 2 previous before selection and 2 after selection in line chart

swuehl — Fri, 02 Dec 2011 22:37:40 GMT

Maybe like attached?

In the script, I used

makedate(right(Volume,4),subfield(right(Volume,7),'/')) as Date

to create a Date with a numerical representation, which allows it to use this as line chart expression:

=sum({<Date={">=$(=addmonths(max(Date),-2))<=$(=addmonths(max(Date),2))"},Volume >} Sales)

Hope this helps,

Stefan

Re: Set Analysis for Line Chart that shows 2 previous before selection and 2 after selection in line chart

Fri, 02 Dec 2011 22:40:25 GMT

Thank you very much.