How can i access data from data structures with QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Full disclosure is I am using QuickBooks Advanced Reporting which is a watered down version of QLikView. I appreciate if anyone could assist me from this forum.

I would like to understand how I can access data from charts in QLikView (I believe these are referred to as machine data in the "Working with QlikView.pdf). Each chart in QLikView is an instance of a "chart" data structure which is populated with data from my database sorted by dimensions and analyzed with expressions. Please consider the following:

My chart is called "CH01" and I have three dimensions "Item Type", "Item", and "Txn Type". "Txn Type" contains expressions "Date", Transaction No.", "Quantity", "Avg. Sales Price" therefore the data structure will visually appear as follows:

CH01

- Item Type (dimension)

- Item (dimension)

- Txn type (dimension)

- Date (expression)

-Transaction No. (expression)

- Quantity (expression)

- Avg. Sales Price (expression)

Please tell me how I can access the data outside of the CH01 data structure. In other programming languages I would access the data in a manner similar to:

CH01.[Txn type].[Avg. Sales Price] <--- using brackets since names with spaces to be enclosed in brackets...

Average sales price is an expression I created (weighted average price based upon actual sales prices and quantity).

The issue I have is it appears each data structure is only able to see native database table

Please let me know how I can access data within a table that I have created so I can display or further filter it?

Please help!

Respectfully,

topic How can i access data from data structures with QlikView in QlikView

How can i access data from data structures with QlikView