topic Re: getting dynamic values in the chart in QlikView

getting dynamic values in the chart

Thu, 19 Nov 2015 10:17:01 GMT

getting the dynamic values ,in the chart ,as the data comes on every monday of the week,how to update or write a code according to that.

Re: getting dynamic values in the chart

swuehl — Thu, 19 Nov 2015 15:09:26 GMT

I think I don't understand your request.

If you want to refresh your data, in general you need to do a (partial or full) reload, using the reload functionality of your desktop client or server. This executes the script, retrieving new data from your sources, updates the data model, so you can then access the new data in your charts.

Re: getting dynamic values in the chart

Fri, 20 Nov 2015 03:17:02 GMT

currently am doing the development for the same ,so need some direction for starting up like building up the data model an then getting the dynamic values in the chart.

Re: getting dynamic values in the chart

PrashantSangle — Fri, 20 Nov 2015 03:45:44 GMT

Hi,

You need to reload your data using reload functionality.

You can acheive this by QlikView Management Console

Create Batch file and execute your batch file on every Monday or Tuesday.

How to reload your dashboard using QMC or Batch file search on Community you will get desired solution.

Regards

Re: getting dynamic values in the chart

Fri, 20 Nov 2015 05:16:50 GMT

istead of loading data from the excel file mentioning the hardcoded path as (c://qlikview ...........) etc

it has to be dynamic

Re: getting dynamic values in the chart

swuehl — Fri, 20 Nov 2015 09:57:03 GMT

I would suggest that you do the tutorial, attend a developer course or read some of the recommended books like 'QV11 for developers' by Garcia & Harmsen, which covers all basics.

There are also a lot of useful blogs and documents here in the forum, start with the blog by Henric Cronstroem and maybe

Get started with developing qlik datamodels‌

The information you have provided so far about your setting and requirements is far too few to enable us to help you.

Re: getting dynamic values in the chart

Anonymous — Fri, 20 Nov 2015 10:17:30 GMT

Shivali your qtn is not clear .. Can you elaborate.

Give some example.

Thanks

BKC

Re: getting dynamic values in the chart

Anonymous — Fri, 20 Nov 2015 10:18:36 GMT

If you want to load your files from a particular location or you want to use some variable to define path .. Plz explain .

Thanks

BKC

Re: getting dynamic values in the chart

Fri, 20 Nov 2015 11:23:00 GMT

my requirement is:

we have some excel files(which are stored on a sharepoint site) genearted on every monday of the week by running some backend query,but currently we are trying that if we could generate those reports in qlikview so need to write the logic for this as ,it should take the latest file append with the old data and genearte the report in qlikview

Re: getting dynamic values in the chart

Mon, 23 Nov 2015 04:46:41 GMT

looking forward for the response.