topic dynamic formula for a chart in Water Cooler

dynamic formula for a chart

Fri, 16 Mar 2012 08:21:13 GMT

Hello everyone,

i have a project where i need to have a dynamic formula for a barchart.

Background:

My importscript imports all qvd-files from a directory, which all have that same struckture but different values.

It is possible, that everyday a new qvd-file is added to the directory.

Every file has the same name, except the last charakter. f.e. qlikview_1.qvd , qlikview_2.qvd , qlikview_3.qvd etc...

If this happends, i get a new table in qlikview.

Now i just want to show the new values in the same barchart where i already show the old values.

The first idea i had, was to use a for-loop, but Qlikview doesn't allow for-loops in a chart-formula.

It's not practicable to creat a new formula everyday by hand.

greetings

Soeren

Re: dynamic formula for a chart

manojkvrajan — Tue, 20 Mar 2012 16:24:39 GMT

Hi Soeren,

Need some more inputs to answer your question. Do you want to show both old (qlikview_1.qvd) and new values (qlikview_2.qvd) in the bar chart or just want the new qvd to be populated with the data?

Thanks,

Manoj

dynamic formula for a chart

Tue, 20 Mar 2012 20:38:58 GMT

Hi Manoj,

i want to show both. Old and new values. At the end i want to create a trend (income-costs) for a project over some month where i can see how the project went form the begin to the mid or end of the project.

greetings

Soeren