Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
lavrendis
New Contributor

Link a table with a chart

Hi,

i have a chart with different dimensions and measures with script filters. I want to have a table in the sheet that depicts the data of the chart . How can i do this? It seems that the table shows a lot more data than the chart. It takes into account only the filter panes of the sheet. (Which seems logical)

Thank you.

Lawrence

Tags (1)
1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Link a table with a chart

Two ways.

1. If there is a direct association on date then the table should automatically filter down

2. If the association is indirect then use set analysis to join the table dates where appropriate with the ones above something like

tablemonth=p(chartmonth) in your set analysis.

8 Replies
vinieme12
Esteemed Contributor II

Re: Link a table with a chart

if you have the same dimensions as in your chart then you will not have any extra rows

sudeepkm
Valued Contributor III

Re: Link a table with a chart

To view the tabular format of the chart you can select FAST Type change option in your Chart to switch to Straight table or pivot table view.

T249467.PNG

ogster1974
Honored Contributor II

Re: Link a table with a chart

In this example I have a chart and table dynamically changing dimensions based on a variable I set.  Is this what you are thinking of?

Makes Sense to go round in circles

lavrendis
New Contributor

Re: Link a table with a chart

Hi, I think you are talking about Qlikview but i have Qliksense.

lavrendis
New Contributor

Re: Link a table with a chart

2017-02-14 15_50_22-Clipboard.pngSo, i have the above graph and info, mostly coming from set analysis. I would like to have the below table show exactly the data from the graph. If i choose for example January i should see only 194 lines in the table. How can i do this?2017-02-14 15_51_14-Qlik Sense Desktop.png

Thanks in advance,

Lawrence

ogster1974
Honored Contributor II

Re: Link a table with a chart

depends how your underlying data model is setup.

If you have an association either directly or indirectly on January then your data in the third table will filter automatically.

Easiest way to check is to include the field in your third chart then filter on your other chart.  If you add the field and January has a bunch of null values in the columns next to it then you know you need to do some work on your model.

Hope this helps

Andy

lavrendis
New Contributor

Re: Link a table with a chart

Hi there,

i have realized that what is missing are the duplicate line. This means that for every customer order there are several lines which the table does not show. This is why in the upper table i have always a bigger number of lines that the actual in the lower table.

Any ideas how can i align the 2 tables?

Thank you in advance,

Lawrence

ogster1974
Honored Contributor II

Re: Link a table with a chart

Two ways.

1. If there is a direct association on date then the table should automatically filter down

2. If the association is indirect then use set analysis to join the table dates where appropriate with the ones above something like

tablemonth=p(chartmonth) in your set analysis.