topic Re: for loop in variable in QlikView

for loop in variable

santhosh_k_n — Tue, 13 May 2014 04:27:56 GMT

Hi All,

Is it possible to use for loop in a variable.?

Thanks,

Santhosh

anbu1984 — Tue, 13 May 2014 05:14:10 GMT

Can you elaborate more on your requirement?

santhosh_k_n — Tue, 13 May 2014 05:23:29 GMT

my requirement is to display volume for rolling 28 days in a line chart where x-axis is days and y-axis is volume

consider table :

date	date-28	volume expression to be in chart
13/05/2014	15/04/2014	sum({<date = {>=15/04/2014,<=13/05/2014}>}quantity)
12/05/2014	14/04/2014	sum({<date = {>=14/04/2014,<=12/05/2014}>}quantity)
..
..
01/05/2014	03/04/2014	sum({<date = {>=03/04/2014,<=01/05/2014}>}quantity)

This what i required

Table represent seems easy but dynamically should display volume for last 14days

Tue, 13 May 2014 05:54:36 GMT

You should create an Asof Table

See a doc I have written on that topic:

Gysbert also explained this topic.

Fabrice