topic Re: Getting totals from various charts in QlikView

Getting totals from various charts

Anonymous — Fri, 26 Feb 2016 14:12:37 GMT

Hello,

I'm looking for some suggestions in what I'm looking for. Say I have a sheet with two charts - SQLChart and OracleChart.

As the name suggests, SQLChart gets data from MSSQL while OracleChart gets data from Oracle. Both charts have

various calculations/expressions and both are pivot charts. I need to get a value out of the SQLChart and use it in my OracleChart

to perform a simple division. How do I do this and what would be the best approach?

Thank you

Re: Getting totals from various charts

Anonymous — Fri, 26 Feb 2016 14:16:51 GMT

Is it possible to "reference" a value which is stored in the SQLChart from the OracleChart?

Re: Getting totals from various charts

Digvijay_Singh — Fri, 26 Feb 2016 14:25:36 GMT

Each Qlikview document can have only one data model. First you should be preparing your holistic data model by first extracting data from Oracle and/or SQL database and then associating your data through script based on business needs or requirement.

Once you are ready with your data model, you will understand how different fields should get associated with each other in front end through charts.

Re: Getting totals from various charts

Anonymous — Fri, 26 Feb 2016 18:29:00 GMT

I totally agreed with you about having a holistic view of the data model. This QV app was created by someone and I'm new to QV development. I was trying to see if there was an easier way for me to pull this one number out of the SQLChart and use it in my OracleChart. One thing I can probably do is somehow setup a formula and stick the result in variable. Then reference this variable in the chart where I need to the math.